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! 😃