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]
