作者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