Funky Query Question

[Guest]

I'm building a new query that uses 2 inputs; a query and a table. The input
query has 3 fields (a,b,c) that combine to be a unique identifier for each
record. The input table has the same 3 fields (a,b,c) that make a unique
identifier for each record.

I'm trying to match records from each input source using all 3 keys (a,b,c),
incldung a field from the table in the new record. But my new query output
only includes the first match of the unique identifier (a,b,c), and doesn't
pick up the rest of the matches (a,b,d - b,c,f - c,d,h - etc.)

I've tried various combination of join properties to no avail. Suggestions
greatly appreciated.

Thanks

 

[Guest]

doesn't pick up the rest of the matches (a,b,d - b,c,f - c,d,h - etc.)
I read your post and it seems like a,b,c are fields. How can you expect
fields a,b,d to match also?

Try posting your SQL for a look-see.