try-- select distinct a.* from bargain_info a, shop_info b, user_info c where a.gridusername=b.gridusername and a.gridusername=c.gridusername
bargain_info有字段code,gridusername,shopusername,gridcode有两条数据, shop_info,user_info表各有一条数据,也有gridusername字段,然后三表连起来,--select * from user_info a left join shop_info b on a.gridusername = b.gridusername left join bargain_info c on a.gridusername = c.gridusername
select * from bargain_info a join shopinfo b on a.gridusername=b.gridusername join user_info c on a.gridusername=c.gridusername
http://topic.csdn.net/u/20090415/21/999c9ae5-125c-47a7-a158-d88061627a15.html
select
distinct
a.*
from
bargain_info a,
shop_info b,
user_info c
where
a.gridusername=b.gridusername
and
a.gridusername=c.gridusername
shop_info,user_info表各有一条数据,也有gridusername字段,然后三表连起来,--select *
from user_info a
left join shop_info b on a.gridusername = b.gridusername
left join bargain_info c on a.gridusername = c.gridusername
select * from bargain_info a join shopinfo b
on a.gridusername=b.gridusername
join user_info c on a.gridusername=c.gridusername