如何两张表关联查询 select * from table1 a,table2 b where a.id = b.lid
===
select a.anme, b.bname, c.value
from a,b,c
where a.aid = c.aid and b.bid = c.bid
------------------
select*
from tl_tsoft_Material_type a,tl_tsoft_Material_type_gfty b,tl_tsoft_Material c
where a.matyid = b.matyid and b.matygfid = c.matygfid
=====
select a.aname,b.bname,c.value from c inner join a on c.aid=a.aid inner join b on c.bid=b.bid