Re: [repost] Finding table name when using Union

2003-03-11 Thread Martin Waite
On Tue, 2003-03-11 at 07:33, Richard Taubo wrote: > > When using the Union statement in MySQL, is it possible to retrieve the > corresponding table name for a given row? The reason I need to know > this is that I present info from different tables in their own way. I > know I can create a colum

[repost] Finding table name when using Union

2003-03-10 Thread Richard Taubo
Hi! Sorry for the repost, but I am really eager to hear the verdict so I give it another go, thanks ;-) When using the Union statement in MySQL, is it possible to retrieve the corresponding table name for a given row? The reason I need to know this is that I present info from different tables