RE: Duplicates returns in query?

[Erich Beyrent]

You have no join criteria between your tables.

Of course.  I am so stupid...

select 
  e.EventID, 
  date_format(e.EventDate, '%c/%d/%y') as EventDate,
  e.EventTime,
  e.EventDetails,
  e.VenueID,
  v.VenueName, 
  v.VenueID, 
  v.VenueURL,
  v.Directions
from 
  events e, 
  venues v
where
  e.VenueID = v.VenueID;


Works beautifully!

Thanks all!

-Erich-





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]