Hi,
I am new to mysql.I have doubt in selecting the rows.
For example:
I have two tables like Table1 and Table2. I have to use the join query and I have to get Result(Specified below)

Quote:

Table : 1
A B C
1 null 123
1 5 456
3 7 788
1 null 888
2 null 888
1 4 888
1 5 888

Table :2
B B1 B2
5 Usa Good
7 Canada Good
4 India Good
5 Ussr Good

My expected result is
A B B1 C
1 null null 123
1 5 Usa 456
3 7 Canada 788
1 null null 888
2 null null 888
1 4 India 888
1 5 Ussr 888




Could any body help me.

Thanks in advance

Regards,
nkpsu.