Announcement

Announcement Module
Collapse
No announcement yet.

select null value from table

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • select null value from table

    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.
Working...
X