I have three tables:
Users has the
id column, that column is related on
Users_request.id is related with
I try to do:
Users table has a column called
name and User_applications has
I want to "print" only those columns with their rows through JOIN clause.
user| application_name| -----|------------------ user1| application1 user2| application2 userN| applicationN
I have the next, but I want improve it not using hardcode
SELECT Users.id, Users_applications.name FROM Users, Users_applications WHERE Users.id = 'User1' AND User_applications.id = n ;
Is there any other way to accomplish it, through only
Users.id using JOIN clauses?
Thanks in advance.