Which join should I use ?

[johnbest]

Hello,

I have 2 tables;

Table A
id val
1 2
2 12


3 11
4 23

Table B
id per
1 10
2 20
3 30
4 40
5 50
6 60

The output, I want is;

id val per
1 2 10
2 12 20
3 11 30
4 23 40
5 50
6 60

Which Join should I use? I am using Access 2007.


Regards
John

[pbaldy]

Start with any join, then edit the join and select the one with the description that fits. Then view the query in SQL view and see which it was.

[johnbest]

Hi pbaldy,

I tried a lot, but in vain.

Please help me.


Regards
John

[johnbest]

Hi pbaldy,

Thanks... a lot...
I was trying it wrong way



Regards
John

[pbaldy]

Happy to help.