How do I join three tables and return information even if it is in only two of the tables
Please visit the following link:
I have my query setup as the example the issue is I need information to be returned even if it is not in all three tables. Example: I have table A, B and C. A is student names and addresses. B is contact information for students. C is transportation information for students. All students are in table A and table B. In table C only students that have transportation information are in the table. When I run my query with the two left joins and I do not get all the students, I only get the students that are in all three tables. How do I get all the information for students from table A and table B even if they are not in table C? Thanks!
I was able to solve this by adding IS NULL for table B and C in the WHERE statement.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.