# select null value from table **URL:** https://forums.percona.com/t/select-null-value-from-table/501 **Category:** Other MySQL® Questions **Created:** [October 24, 2007, 8:38am UTC](https://forums.percona.com/t/select-null-value-from-table/501 "2007-10-24T08:38:58Z") **Posts on this page:** 1 **Page:** 1
### Author: ![nkpsu](https://avatars.discourse-cdn.com/v4/letter/n/ea666f/32.png) [@nkpsu](https://forums.percona.com/u/nkpsu) #### Post date: [October 24, 2007, 8:38am UTC](https://forums.percona.com/t/select-null-value-from-table/501/1 "2007-10-24T08:38:58Z")
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.