Please, re-send me:
* mysqldump of the tables
* the exact UNION query that you ran
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnac
artfully decorated. Just 5 minutes north
of the Golden Gate Bridge. | yes | no | yes | 12884 | y
|| y | | y | | y | y|
again, having some duplicates listed twice that should not be there.
----- Original Message -
From: "Sinis
Here is the dump of those tables being used:
allusa:
+--++--+-+--+---
+
| Field| Type | Null | Key | Default |
Extra |
+--++--+-+--+---
cliff,
Thursday, August 01, 2002, 11:46:28 PM, you wrote:
>>Description:
c> The UNION clause displays results 2 times even when not using the
c> ALL keyword with it. example: (SELECT
c>
allusa.id,line,name,city,country,listcity,state,liststate,url,line,bookable,cost_range_low,cost_range_
