List:General Discussion« Previous MessageNext Message »
From:m i l e s Date:November 19 2005 5:35pm
Subject:Inner Join & Search on Two (2) fields ?
View as plain text  
SELECT events.name_short, events.type, events.location,  
events.description, events.faculty, concat(people2.First_Name,  
people2.Last_Name) as zName, people2.roles
FROM events INNER JOIN people2 ON events.faculty = people2.id
WHERE people2.roles = "faculty" AND zName = "some name"

Is this SELECT statement correct ?

M i l e s.

Thread
Inner Join & Search on Two (2) fields ?m i l e s19 Nov
  • Re: Inner Join & Search on Two (2) fields ?Michael Stassen19 Nov
    • Re: Inner Join & Search on Two (2) fields ?m i l e s19 Nov
  • Re: Inner Join & Search on Two (2) fields ?Peter Brawley19 Nov