帮看看这个sql语法有没有问题

[cnljc]

select a.*,b.id from a.Goodsimage,b.Goodsinfo
where a.sortid=1 and a.gid=b.id and b.typeid=21
order by a.id desc

图片表Goodsimage,信息表Goodsinfo

这句语法有问题没有？？

[hookee]

select a.*, b.id as bid from Goodsimage a, Goodsinfo b
where a.sortid=1 and a.gid=b.id and b.typeid=21 
order by a.id desc

[ygyjack]

没有问题.

[ygyjack]

a.Goodsimage,b.Goodsinfo
哦, 表名....