| difficulty Framing a query [message #444] |
Tue, 12 February 2002 22:01  |
Titoo
Messages: 4
Registered: January 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
