joins

[nat35]

Hi there,
I have 2 tables.Table1 has id_num 18 and 9.Table2 has only 9 I want both id_num 18 and 9 from Table1 link to id_num 9 from Table2

thanks
natalia

 

[amorous]

try:

SELECT t1.id_num From Table1 t1
Left Join Table2 t2
ON t1.id_num=t2.id_num

-VJ

 

[nat35]

thank you for replay but it is not want i want

Table1 Table2
18 Mum 9 A
9 dad 9 b

I want the result

18 Mum A
18 Mum b
9 Dad A
9 Dad b

is it possible?

 

[nat35]

No worries ,I ve worked out how to do it
thanks
Nat