- ELECT t.name,
- SUM(i.quantity),
- playlist_id
- FROM track AS t,
- playlist_track AS p
- INNER JOIN invoice_line AS i ON t.track_id=i.track_id
- INNER JOIN playlist_track AS i ON t.track_id=P.track_id
- --GROUP BY t.name,
- -- t.track_id-- добавьте новое поле для группировки
- --LIMIT 20-- добавьте ещё одно присоединение;
Re: Re: Untitled
From Silly Zebra, 4 Months ago, written in Plain Text, viewed 80 times.
This paste is a reply to Re: Untitled from Sweltering Shama
- view diff
URL http://codebin.org/view/b7b3b3f8
Embed
Download Paste or View Raw
— Expand Paste to full width of browser