1 like 0 dislike
23 views
in Mysql by
reshown by anonymous
Mysql join sorguları nasıl yazılır ?

1 Answer

0 like 0 dislike
by

SELECT * FROM invoice LEFT JOIN invoice_type ON invoice.invoice_typeid = invoice_type.id

SELECT i.total, i.created_date FROM invoice i LEFT JOIN invoice_type it ON i.invoice_typeid = it.id WHERE i.status=1 ORDER BY i.created_date DESC

...