If you have three tables: I want all the data from table a and b and matching data from table c only that table c contains nulls or blanks. How can I join these tables to work.
Table relationships require more information than "data from table a nd b.
And what would matching data from C mean if they are null, do you mean that you want the nulls from A and B, because if they match they'll all be nulls, right?
GEnerally people will post example data to aiid in postings.
It sounds like you want to join A to B, then a left outer to C, and in the report->edit selection formula->record, palce:
isnull(c.field)
or
c.field = ""
Hard to say exactly, try taking a few moments to think through your post and supply sufficient information in the future.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.