清 清儿 Unregistered / Unconfirmed GUEST, unregistred user! 2001-11-29 #2 select table1name.字段名1，tabel1name.字段名2，...table2.字段名1，...tablen.字段名1， tableNname.字段名2，...tableNname.字段名N from 所有的表名 where 所有的条件
select table1name.字段名1，tabel1name.字段名2，...table2.字段名1，...tablen.字段名1， tableNname.字段名2，...tableNname.字段名N from 所有的表名 where 所有的条件
萧 萧月禾 Unregistered / Unconfirmed GUEST, unregistred user! 2001-11-29 #6 select t1.field1, t1.field2, t2.* from table1 t1, table t2 where t1.field1 = t2.field2 and t1.field3 = t2.field100
select t1.field1, t1.field2, t2.* from table1 t1, table t2 where t1.field1 = t2.field2 and t1.field3 = t2.field100
