Error: SELECT InvID as id ,a.Hollander,a.Description,a.ICDescription,a.Conditions,a.Stock,a.PriceRetail AS price,b.state ,a.Part FROM tabinventory a,vendors b WHERE a.Yard=b.id AND AND a.PriceRetail> 0 ORDER BY a.PriceRetail asc

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.PriceRetail> 0 ORDER BY a.PriceRetail asc' at line 4