Inner Join & Search on Two (2) fields ?

[m i l e s]

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.


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