I have 2 tables, Table1 and Table2 with common key.
Table2 has 3 fields: key, position and value, where record with same key may have position 1,2,3 etc
eg of records may look like: (key,position,value)
I like to print the value from Table2 with position=2 only.
if I specify position=2 in selction formula, then C will not print as C does not have postion=2. But I like to include ALL records from Table1, regardless whether it has corresponding record in Table2 with position=2.
the report should look like:
B (exist in table1)
C (no position=2)
E (no position=2)
Hope I make it clear enough.
many thks for helping.