OraFAQ Forum: SQL & PL/SQL » Difficulty Framing a Query

Home » SQL & PL/SQL » SQL & PL/SQL » Difficulty Framing a Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difficulty Framing a Query [message #18740]

Tue, 12 February 2002 21:56

Alfred
Messages: 1
Registered: February 2002

Junior Member

Hai There
Can anyone help me out with the situation given below:-

There are 2 tables
Clients and Assets

Here is the Structure
1. Table : Clients
Column(s) : client_id

2. Table : Assets
Column(s) : asset_id

Clients has 2 rows
George
Albert

Assets has 2 rows
Abcz
Cupid

I want to frame a query such that the output looks as follows

client_id asset_id
-------------- ------------
George NULL
Albert NULL
NULL Abcz
NULL Cupid

IF NULL is replaced by blank spaces also ,no problem.

If i could get reply to this problem ,it would have been very useful to me.

Thanks and regards,
alfred

Report message to a moderator

Re: Difficulty Framing a Query [message #18742 is a reply to message #18740]

Tue, 12 February 2002 23:41

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

select client_id,'null' from clients
union
select 'null',asset_id from assets

Report message to a moderator

Previous Topic:	ORA-02266: unique/primary keys in table referenced by enabled foreign keys
Next Topic:	Difference between 'exists' and 'in'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:52:46 CDT 2024