2021-05-17
1.SELECT xh,xm,xb,bjmc FROM bjb,xsb WHERE xsb.bjb_id=bjb.id;
2.SELECT xh,xm,xb,bjmc,yw,sx FROM bjb,xsb,cjb WHERE bjb.id=xsb.bjb_id AND xsb.id=cjb.id;
3.SELECT bjb_id,bjmc,COUNt(bjb_id) FROM bjb,xsb WHERE xsb.bjb_id=bjb.id GROUP BY bjb_id;
4.SELECT xh,xm,bj
原创
2021-05-17 18:52:57 ·
154 阅读 ·
1 评论