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