RE: get table name from select staement as output as field

2003-03-30 Thread Dan Rossi 
thanks heaps that works abosultely fine

-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 6:00 PM
To: Daniel Rossi
Cc: [EMAIL PROTECTED]
Subject: RE: get table name from select staement as output as field



On 30-Mar-2003 Daniel Rossi wrote:
 hi guys is this possible ? select tablename1 as table1, id from
 tablename1 , tablename2 ?


select 'tablename1' as table1, id from ...

Regards,
--
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

get table name from select staement as output as field

2003-03-29 Thread Daniel Rossi 
hi guys is this possible ? select tablename1 as table1, id from tablename1 , 
tablename2 ?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: get table name from select staement as output as field

2003-03-29 Thread Don Read 

On 30-Mar-2003 Daniel Rossi wrote:
 hi guys is this possible ? select tablename1 as table1, id from
 tablename1 , tablename2 ?
 

select 'tablename1' as table1, id from ...

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]