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 π π.
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! πͺ
Thanks, @ijsucceed . I'm glad you are becoming an SQL Savant! π