MySQL - specific columns on join?

user_553609 0
Viewed 27196

When making a join (inner, left outer, right outer or whatever), how can I specify which columns on the table to join into the original table?

Consider the following example:

SELECT FirstName FROM User LEFT OUTER JOIN Provider ON User.ProviderID = Provider.ID

This would select FirstName from user, but select everything from Provider. How can I specify which parts of Provider should be included in the resultset?

mysql sql
4 Answers
Related