DEV Community

Discussion on: The SQL Savant: Inner Joins in SQL

Collapse
 
ijsucceed profile image
Jeremy Ikwuje • Edited

I could hear your voice in this write-up πŸ‘.

Thank you for mentioning the USING keyword. It's clean, compare to p.id = g.id.

Having encountered 6.md several times, what I do is to use PHP logic to remove duplicated results 😏. But it becomes difficult with several multiple JOIN.

Never knew one could just append the AND keyword without HEADACHE πŸ˜ƒ πŸ˜ƒ.

Seems I becoming an SQL savant! πŸ’ͺ

Collapse
 
joyadauche profile image
Joy Ada Uche • Edited

Thanks, @ijsucceed . I'm glad you are becoming an SQL Savant! πŸ˜ƒ