有两个表.一个a表:字段是:cid(主键),nama,intro,sum
一个b表:字段是:id,address,cid(外键)
现在我用gridview显示出出:cid,name,intro,sum,address
请问这个sql语句怎么写?
没分了!不好意思了!
谢谢
------解决方案--------------------------------------------------------
- SQL code
select a.cid, a.name, a.intro, a.sum, b.address from a inner join b on a.cid = b.cid
------解决方案--------------------------------------------------------
select a.cid, a.[name], a.intro, a.[sum], b.address from a inner join b on a.cid = b.cid