关于SQL的问题

Question

SELECT TABLE1.*,TABLE2.FIELD1,TABLE2.FIELD2 FROM TABLE1,TABLE2 WHERE TABLE1.FIELD1=TABLE2.FIELD1;

Answer 1

Select a.*,b.Field1,..,b.Fieldn
from Table1 a,Table1 b
where a.OID=b.OID

Answer 2

select table1.field1,...,table2.field1,...
from table1,table2
where table1.field=table2.field
(两个表中必须有一个相同的字段，存储相同的数据)