List:General Discussion« Previous MessageNext Message »
From:Erich Beyrent Date:March 4 2004 4:32pm
Subject:RE: Duplicates returns in query?
View as plain text  
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-




Thread
Duplicates returns in query?Erich Beyrent4 Mar
  • Re: Duplicates returns in query?vpendleton4 Mar
    • RE: Duplicates returns in query?Erich Beyrent4 Mar
  • Re: Duplicates returns in query?Richard Davey4 Mar
  • Re: Duplicates returns in query?Rhino4 Mar