MySQL Performance: MySQL => select null value from table

Members

Help

Home

Home » Performance » MySQL » select null value from table

Show: Today's Messages :: Show Polls :: Message Navigator

select null value from table [message #2130]

Wed, 24 October 2007 10:08

nkpsu
Messages: 1
Registered: October 2007

Junior Member

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.

Attachment: I have a situation in mysql query.docx
(Size: 11.42KB, Downloaded 157 time(s))

Report message to a moderator

Previous Topic:	Replication Server Serving SELECT Queries
Next Topic:	Online Index Creation and Schema Changes

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 22:09:10 EDT 2009

Total time taken to generate the page: 0.00557 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.