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/
