maybe:
SELECT value AS fname, null as lname , null as email FROM table WHERE
fieldid = 1
UNION ALL
SELECT NULL, value AS lname, NULL FROM table WHERE fieldid = 2
UNION ALL
SELECT NULL, NULL, value AS email FROM table WHERE fieldid = 3
And then maybe group?
then remove rows where all three columns are null? or something?
>>> [EMAIL PROTECTED] 4/05/2005 2:32:02 pm >>>
Is it possible to reuse the same table as a sub select when creating a
view?
What i want is
SELECT value AS fname FROM table WHERE fieldid = 1
But i also want to :
SELECT value AS lname FROM table WHERE fieldid = 2
As well as
SELECT value AS email FROM table WHERE fieldid = 3
so if 'table' looked like :
fieldid,value
-----------------
1,firstname
2,lastname
3,[EMAIL PROTECTED]
my view would return
fname,lname,email
---------------------------
firstname,lastname,[EMAIL PROTECTED]
What would be the correct syntax for that? Is it even possible?
Thanks;
Ricardo.
---
You are currently subscribed to cfaussie as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
