I have 2 separate tables which are tuition and user. In the tuition table I have 2 fields named user_id and admin_id. I access related users by using Inner Join clause and user_id:
SELECT * FROM tuition t JOIN user u ON t.user_id = u.id
But in the tuition table, I want join only records in tuition which their admin_id is equal to 1. How should I rewrite the clause above? I wrote as this but didn’t show me anything:
SELECT * FROM tuition t JOIN user u ON t.user_id = u.id WHERE admin_id=1
SELECT * FROM tuition t WHERE admin_id=1 AND JOIN user u ON t.user_id = u.id
>Solution :
Where clause with inner join queries should be referenced with table name.
SELECT * FROM tuition t JOIN user u ON t.user_id = u.id WHERE table_name.admin_id=1