sammybee77
Technical User
Hi All,
I'm having a few problems I have a report that is outer joined, I want to do a select on the table which is outer joined but still display all the matches. E.g.
Table1 has an id that = 12. Table2 has several rows that have a link on the id 12 and the results show a list of countries e.g
id country
12 england
12 Germany
12 France
I'm trying to select where Table 2 = England, but still show all the other countries. When I do this the result won't show all just England. Any ideas?
Many thanks
Sam
I'm having a few problems I have a report that is outer joined, I want to do a select on the table which is outer joined but still display all the matches. E.g.
Table1 has an id that = 12. Table2 has several rows that have a link on the id 12 and the results show a list of countries e.g
id country
12 england
12 Germany
12 France
I'm trying to select where Table 2 = England, but still show all the other countries. When I do this the result won't show all just England. Any ideas?
Many thanks
Sam