Advertisement
manul1537

Untitled

May 19th, 2024 (edited)
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT name,
  2.        CAST(i.invoice_date AS date) AS date_invoice
  3.        -- поместите поле с датой
  4. FROM track AS t-- определите левую таблицу
  5. LEFT JOIN invoice_line AS il ON t.track_id = il.track_id
  6. LEFT JOIN invoice AS i ON il.invoice_id = i.invoice_id;-- определите вариант присоединения первой таблицы
  7.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement