Miles,
>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 ?
Nope, you can't reference a column alias ('zname') in a WHERE clause.
PB
-----
m i l e s wrote:
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.
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.4/175 - Release Date: 11/18/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
