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: >

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