如下两表: table1 table2
-------------------- -----------------------
id name id state
-------------------- -----------------------
1 tom 1 good
2 jack
-------------------- ------------------------用“select * from table1,table2 where table1.id=table2.id”语句的返回结果如下:-----------------------------------
id name state
-----------------------------------
1 tom good
-----------------------------------而我想返回:-----------------------------------
id name state
-----------------------------------
1 tom good
2 jack
-----------------------------------该怎么办呢?用什么语句?
-------------------- -----------------------
id name id state
-------------------- -----------------------
1 tom 1 good
2 jack
-------------------- ------------------------用“select * from table1,table2 where table1.id=table2.id”语句的返回结果如下:-----------------------------------
id name state
-----------------------------------
1 tom good
-----------------------------------而我想返回:-----------------------------------
id name state
-----------------------------------
1 tom good
2 jack
-----------------------------------该怎么办呢?用什么语句?
--两边都能显示
select * from table1 left join table2 on table1.id=table2.id
-table1都能显示
能详细点吗?给一条sql语句!
谢了