Re: Join with Union

2002-08-28 Thread Dan Nelson
In the last episode (Aug 29), suresh said: > I dont really get your point Another thing I would like to highlight > I thought UNION will be used to join to SQL Queries and will display > only distinct values unless UNION ALL is used > > I don't know why the result is wierd or I do some misunderst

Re: Join with Union

2002-08-28 Thread Paul DuBois
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

Re: Join with Union

2002-08-28 Thread Dan Nelson
In the last episode (Aug 29), suresh said: > 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. Is there any way to > join 3 or more tables having different