Regarding Pseudo Columns [message #312678] |
Wed, 09 April 2008 10:40  |
saharookiedba
Messages: 56 Registered: September 2007 Location: PUNE
|
Member |
|
|
Hi,
I have a problem in Query,
I have a table softwares_pc_user where i store data regarding softwares belonging to a particular PC or User..
The Rule is, at a time a software cannot belong to a User and PC.
I have records like
pc user software
0 100 x
0 101 y
12 0 z
Now while Querying, i want to select only software and a pseudocolumn say Usedby which is a flag giving below results
software UsedBy
x u
y u
z PC
Here Usedby will give 'u' if for that record PC is zero,
similarly for PC
Please help me in this...
Thank you....
|
|
|
|
|