求一简单SQL,急，在线等！
products表中有分类表category1,category2,category3的主键ID，怎么查询products时把category1id,category2id,category3id转为categoryName1,categoryName2,categoryName3 ?
[解决办法]
--try
select * from products
left join category1 on category1.category1id=products.category1id
left join category2 on category2.category2id=products.category2id
left join category3 on category3.category3id=products.category3id
[解决办法]
as
