select null value from table

MySQL & MariaDB Other MySQL® Questions
1

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)

[B]Quote:[/B]
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.