its ok I solved with the below for anyone that was interested.. 🙂
SELECT BRANDNAME,MODELNAME,VIEWCARNAME,SOURCENAME,VIDEOCARID,MODELFILE,PUBPATHACTIVE,PUBPATHINTERNETSMALL,PUBPATHINTRANETSMALL
FROM AUTOMOTION,SOURCE,BRAND,MODEL,VIEWCAR LEFT JOIN VIEWPIC
ON VIEWPIC.CARID = VIEWCAR.VIEWCARID
AND (VIEWPIC.MODELVIEW2 = 24 OR VIEWPIC.MODELVIEW2 =...