Hi; I have the following: mysql> select * from categoriesProducts as c inner join relationshipProducts as r on c.ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID where p.Category = prodCat2; ERROR 1054 (42S22): Unknown column 'prodCat2' in 'where clause' mysql> describe categoriesProducts; +----------+-----------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-----------------+------+-----+---------+----------------+ | ID | int(3) unsigned | NO | PRI | NULL | auto_increment | | Category | varchar(40) | YES | | NULL | | | Parent | varchar(40) | YES | | NULL | | +----------+-----------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec)
mysql> select * from categoriesProducts; +----+----------+--------+ | ID | Category | Parent | +----+----------+--------+ | 1 | prodCat1 | None | | 2 | prodCat2 | None | +----+----------+--------+ 2 rows in set (0.00 sec) So I'm at a loss. No, 'prodCat2' isn't a column, but I don't understand how I specified that in my query. Please advise. TIA, Victor
