共 2 篇文章 |
|
select tb_chengji.id,tb_chengji.xuesheng,xingbie,dizhi,yuwen,shuxue,yingyu fromtb_chengji,tb_info where tb_chengji.xuesheng=tb_info.xuesheng and tb_chengji.yuwen>=100;tb_chengji.xuesheng=tb_info.xuesheng将表tb_chengji和tb_info连接起来,叫做等同连接。select xuesheng,sum(fenshu) from tb_chengji02 where xuesheng='... 阅2575 转4 评0 公众公开 16-11-17 08:26 |