作者hukhuk (ken)
看板Database
标题Re: [SQL ] 同一资料表内之查询
时间Sat Oct 6 11:37:48 2012
select a.* from product a
inner join product b on a.manufactures=b.manufactures
where a.company<>b.company
group by a.company
order by a.manufactures,a.company;
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 180.177.216.151