Joining Queries where join requires matching/unmatching data from both tables

[BigJimSlade]

Hey, Big Jim here...

I have table X and table Y

table X has column A, B, C, D
table Y has column E, F, G, H

If X.A = Y.E and X.B = Y.F, I would like to place ABCDEFGH on the same line. If these criteria are not met, I would like the data to still populate, just on seperate rows (ABCD or EFGH).

Anyone have an idea?

Thanks in advance

Big Jim

 

[BigJimSlade]

Thank you for your help, Pat. I appreciate it and hope it can help others.

 

[Happy YN]

no! I can join the fields normally but as soon as i try anouter join I get a message that the sql cannot be done due to ambiguous outer joins and I should first create a query with one join and then connect with that

I forgot to say that this field "month" contains duplicate values but There is another field which makes them unique and which I need to join aswell to the second table.
I know it sounds complicated but it isn't really
I will give more info if required to simplify the problem
thankx

 

[Fornatian]

Happy YN is a little confused, I made reference to this post elsewhere.