SELECT'ing certain fields using JOIN queries 1

[y2k1981]

I don't know how to explain this very well, but how do I select certain fields from different tables using a join query? For example:

SELECT * FROM users LEFT JOIN usersingroups USING (userid) LEFT JOIN groups USING (groupid) WHERE groups.group_type = 'type1'

But suppose, instead of everything, I just want the following fields:
users.userid
users.name
groups.groupid
groups.groupname

If it were just the first 2 fields, I could say users.userid, users.name instead of *, but I don't know how to do it for the second table. can anybody help me at all?

 

[r937]

do it the same way -- replace the * with the list of columns you want, just like that

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[y2k1981]

so you're saying use SELECT users.userid, users.name, groups.groupid, groups.groupname FROM users ... - I've tried that but it doesn't work. anyway, how could it - SELECT groups.gropuid FROM users wouldn't work would it?

 

[r937]

what does "I've tried that but it doesn't work" mean? query ran but produced no results? query ran but produced wrong results? query crashed the server? query didn't run because of syntax error? what was the error?



anyway, how could it work? because you are allowed to select any columns from any table in the FROM clause

note that the FROM clause includes all tables joined together

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[y2k1981]

>> what does "I've tried that but it doesn't work" mean? query ran but produced no results? query ran but produced wrong results? query crashed the server? query didn't run because of syntax error? what was the error?


Sorry, you're right it does work. All the times I tried this before, I was 100% sure it generated an error

Sorry again, and star for your patience !!