Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select Brand, year, a.modelType, j.carType as carType, year,
- transmission, cylinderCapacity, replace(replace(priceRange,'.',''),'Rp','') as priceRange, carTypeID
- from tableRajaMobil2 a
- join (
- select carTypeID,carType, c.modelType from CarType b
- JOIN modeltype c on b.modelTypeID = c.modeltypeID
- where b.carType <> 'default'
- )as j
- where a.carType like concat(j.carType, '%')
- and a.modelType like concat(j.modeltype, '%');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement