On Mon, Jan 10, 2005 at 12:47:53 -0500, Madison Kelly <[EMAIL PROTECTED]> wrote: > > The trick now is I need to know which table each result came from. I can > add another column and record the table number and SELECT that at the > same time but before I do I was wondering if I can do this more > efficiently or elegantly.
You can add a constant to the select list in each of the subselects that indicates which table is being used. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
