cmd.CommandText = "Select {top_trade}.[top_xuhao],[top_seller_nick],[top_print_logistics_time],{top_trade}.[top_tid],[top_buyer_nick],[top_receiver_name],[top_receiver_mobile],[top_receiver_phone],[top_receiver_state],[top_receiver_city],[top_receiver_district],[top_receiver_address],[top_company_name],[top_out_sid],[top_buyer_message],[top_seller_memo],[top_pay_time],[top_trade_from],[top_type],[top_consign_time],[top_synchro_time],[top_invoice_info],[top_title],[top_price],[top_num_iid],[top_sku_properties_name],[top_outer_iid],[top_outer_sid],[top_num],[top_shifu],[top_plain_recv_name],[top_plain_recv_mobile],[top_plain_recv_addr] From {top_order} Right top_outer_sid {top_trade} ON {top_trade}.[top_tid] = {top_order}.[top_tid] Where (" & Filter & ") Or (" & FI & ")"
|