| SELECT top 500 bi_t_cls_info.*,pos_t_sale_detail.*,bi_t_item_info.*,bi_v_branch_info.* from bi_t_item_info, bi_t_cls_info,pos_t_sale_detail,bi_v_branch_info where bi_t_cls_info.cls_no=bi_t_item_info.cls_no and pos_t_sale_detail.item_no=bi_t_item_info.item_no and bi_v_branch_info.branch_no=pos_t_sale_detail.branch_jg and branch_jg=${branch_jg} and cls_name=${cls_name} and item_barcode=${item_barcode} 最后共同关联字段连完了 接参数 用and 不对么 该用什么连 谢谢 |
