4 ms·
The biggest failure of SQL joins is not using declared foreign keys. For example it should be something like "JOIN USING fk_invoice_customer c" instead of repea
by Sankozi 4y ago
The biggest failure of SQL joins is not using declared foreign keys. For example it should be something like "JOIN USING fk_invoice_customer c" instead of repeating each time the relationship between invoice and customer entries already defined in foreign key
- neamar 4y agoMost engines support NATURAL JOIN, which isn't perfect and has drawbacks, but allows for shorter joins.
- deleted 4y ago[deleted]