Help with Query

[Canman2005]

Hi all

 

Just wondering if someone can help me with with my SELECT query

 

SELECT b.name, 

(SELECT value FROM options WHERE id = bc.level1) AS l1,

(SELECT value FROM options WHERE id = bc.level2) AS l2,

(SELECT value FROM options WHERE id = bc.level3) AS l3 

FROM items b LEFT JOIN cats bc ON b.id = bc.item_id WHERE l3 = 'Apple' AND l3 = 'iPod' AND l3 = 'Touch'

 

as I keep getting a

 

#1054 - Unknown column 'l3' in 'where clause'

 

But I cannot figure it out

 

Any help would be great

 

Thanks

[Canman2005]

Any ideas anyone?

[fenway]

"l3" is a table alias -- not a column.