| select *,
c.name as cat, m.name as man,
cast( translate( lower( p.msrp ), ', abcdefghijklmnopqrstuvwxyz', '' ) as float) as mint,
cast( translate( lower( p.price ), ', abcdefghijklmnopqrstuvwxyz', '' ) as float) as pint
from categ as c, manuf as m, parts as p
left join notes on p.id = notes.partid
where c.id = p.categ and m.id=p.manuf and p.manuf = 26 order by sortkey ascDB Error: unknown error |