Query syntax error selecting from 3 tables
- by Toni Michel Caubet
Given info about an object: id, user_id, group_id
Given info about an user: id_user, id_loc
I need to get i one query:
The name of the user (in table users)
The name of the location of the user (in table locs)
The name of the group of the object (in table groups)
I am trying like this:
SELECT usuarios.first_name as username, usuarios.id as…
