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)
A,1,a1
A,2,a2
C,1,c1
C,3,c3
D,2,d2
E,1,e1

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:
A,a2
B (exist in table1)
C (no position=2)
D2
E (no position=2)

Hope I make it clear enough.
many thks for helping.