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 不对么 该用什么连 谢谢