I am needing to retrieve information from about 5 tables total. The problem is that some of the records haven't been entered into two of the tables. Thus, those particular records don't show up, since there isn't a match in ALL the tables.
Our users want to see this information, even if details for a particular instance haven't been fully entered. Is there a way to get the records to show from the three tables even if they haven't been entered into the other two?
My first attempt has been to change the SQL query to group the original where clause in parentheses and then use the keyword 'OR' with a second set of statements that simply exclude the two tables that don't have all the information.
That hasn't seemed to work.
Any suggestions would be greatly appreciated!
Our users want to see this information, even if details for a particular instance haven't been fully entered. Is there a way to get the records to show from the three tables even if they haven't been entered into the other two?
My first attempt has been to change the SQL query to group the original where clause in parentheses and then use the keyword 'OR' with a second set of statements that simply exclude the two tables that don't have all the information.
That hasn't seemed to work.
Any suggestions would be greatly appreciated!