Re: [SQL ] 同一資料表內之查詢

[hukhuk (ken)]

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