You have no join criteria between your tables. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/4/04, 9:23:41 AM, Erich Beyrent <[EMAIL PROTECTED]> wrote regarding Duplicates returns in query?: > Hi all, > I have a problem with a select returning duplicates, even though there > aren't any duplicates in the database. > select > e.EventID, > date_format(e.EventDate, '%c/%d/%y') as EventDate, > e.EventTime, > v.VenueName, > v.VenueID > from > events e, > venues v; > +---------+-----------+-----------+-----------------+---------+ > | EventID | EventDate | EventTime | VenueName | VenueID | > +---------+-----------+-----------+-----------------+---------+ > | 2 | 3/06/04 | 09:00:00 | The Bombshelter | 1 | > | 3 | 3/12/04 | 09:00:00 | The Bombshelter | 1 | > | 2 | 3/06/04 | 09:00:00 | Goodtimes | 2 | > | 3 | 3/12/04 | 09:00:00 | Goodtimes | 2 | > +---------+-----------+-----------+-----------------+---------+ > I tried adding a "distinct" to the above select, which had no effect. I > also ran an "explain" on the query: > +-------+------+---------------+------+---------+------+------+-------+ > | table | type | possible_keys | key | key_len | ref | rows | Extra | > +-------+------+---------------+------+---------+------+------+-------+ > | e | ALL | NULL | NULL | NULL | NULL | 2 | | > | v | ALL | NULL | NULL | NULL | NULL | 2 | | > +-------+------+---------------+------+---------+------+------+-------+ > Which tells me nothing. What have I done wrong here? > -Erich- > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
