At 12:02 +0900 8/29/02, suresh wrote:
>Hi
>I changed from mysql 3.23.49 -nt to 4.0.2 max to make use of union
>
>But one problem when trying to join tables is that UNION works
>only for SELECT queries with same number of coulmns.
Well, that's how UNION works.
> Is there any way to join 3 or more tables having different columns
>using UNION?
Sure, you can use different columns. But you have to have the same
*number* of columns.
> I am writing my query during the runtime. Since the user can select
>any number of fileds from a particular table and also I am using
>LEFT JOIN, I can't make all the tables having same number of fields.
Sure you can. Add fake columns that select some constant value, like
an empty string, 0, or NULL. Pad the "short" tables with enough of these
so that you select the same number of columns from each.
If you don't have any way to tell how many columns are selected, then
you're stuck. But I find it hard to conceive of such a situation.
>
>Thanks for any help

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.