I've three tables and trying to figure out the best way to query them for certain information.
Here are the tables:
uid, fname, lname
I want query for all users (uid, fname, lname, facebook_id) for a given group.
Some users may not have an entry in the users_facebook table.
I have a sense that the left join is the way to go. However, I 'm not sure how to do left join when three tables are involved. In this case, we need to join users_groups and users tables and then do an left join with users_facebook table.
What would be the best way to do it? My database has 100 K users. In terms of performance, would it make sense to split the query?