Hello People
I have 2 tables
table 1 has two columns id and top1, id is not unique
id top 1
1 test1
1 test2
table 2 has two columns id and top2, id is not unique
id top 2
1 test3
1 test4
how do i join both tables or do a query so that I get the folowing result
result :
id top1 top2
1 test1 test3
1 test2 test4
I hope you see what I mean
Thanks
I have 2 tables
table 1 has two columns id and top1, id is not unique
id top 1
1 test1
1 test2
table 2 has two columns id and top2, id is not unique
id top 2
1 test3
1 test4
how do i join both tables or do a query so that I get the folowing result
result :
id top1 top2
1 test1 test3
1 test2 test4
I hope you see what I mean
Thanks