Hi,
Im having a bit of a problem with the following query:
SELECT CONCAT(people2.First_Name, " ", people2.Last_Name) AS zNAME,
events.name_short,
events.date_start
FROM people2 INNER JOIN event_people ON people2.ID =
event_people.peopleID
INNER JOIN events ON event_people.eventID = events.ID
WHERE event_people.people_role = "FACULTY"
HAVING zNAME LIKE "XXXXXXXX"
ORDER BY events.date_start DESC
Specifically, the HAVING statement....
Im trying to perform a search against the concatenated result of
first_name/last_name and not getting very far.
Can anyone point me in the right direction ???
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]