Hi ,
I have two tables: I currently have an outer join getting all the data from Act table where fields match in both tables.
How do i get it so if the table 2 does have data which I want to show and table 1 does not but still matches on my joins.
How do i get it show in the query results?
Any help much appreciated.
E.g
Table1 Table2
dog spider
cat cat
puppy dog
mouse mouse
How would i get the the record spider to go in the report and from and say there 1 spider table 2 and o spider in table 1?
This make sense?
I have two tables: I currently have an outer join getting all the data from Act table where fields match in both tables.
How do i get it so if the table 2 does have data which I want to show and table 1 does not but still matches on my joins.
How do i get it show in the query results?
Any help much appreciated.
E.g
Table1 Table2
dog spider
cat cat
puppy dog
mouse mouse
How would i get the the record spider to go in the report and from and say there 1 spider table 2 and o spider in table 1?
This make sense?
Last edited: