Hi

I am constructing an inner join with php - below is the code that my php code resolves to:

SELECT * FROM `comp-profile-01-general` a INNER JOIN `comp-profile-02-social` b ON `a.co_num` = `b.co_num` INNER JOIN `comp-profile-03-specialties` c ON `a.co_num` = `c.co_num` WHERE `a.co_num` = 300023

I am getting the error:
#1054 - Unknown column 'a.co_num' in 'where clause'

What have i done wrong?


Thanks.