Re: Untitled

From Coral Panda, 4 Months ago, written in Plain Text, viewed 68 times. This paste is a reply to Untitled from Alex - view diff

URL http://codebin.org/view/23b7f023 Embed

Download Paste or View Raw

SELECT 
    t.name AS track_name,
    CAST(i.invoice_date AS date) AS t_date
FROM track AS t
LEFT OUTER JOIN invoice_line AS il ON t.track_id=il.track_id
LEFT OUTER JOIN invoice AS i ON il.invoice_id=i.invoice_id
GROUP BY track_name, t_date

Reply to "Re: Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?