sql 两表关联查询
select a.*,c.*
from a,c
where a.e=c.e
and c.d=1
and a.b=10
对两表进行关联信息SQL查询语句？
table1和table2 是否2113有主外键关5261系？假设4102table1中的1653id 为table2中的外键，可内以这样写 select plan from table2 where id =（select id form table1 where card ="）容
SQL两张表如何关联查询呀？？
select * from table1 a,table2 b
where a.id = b.lid
SQL两表连查如何写语句。查询关连两表
select A.MEDIID,B.PRICE
from A,B
where a.MEDIID=B.MEDIID