CREATE VIEW vSOrders AS ; SELECT orders.*,pubs.pubname,areas.clname,campaign.campaign ; FROM spacead!orders ; INNER JOIN spacead!pubs ON orders.pub_id = pubs.pub_id ; INNER JOIN spacead!aras On orders.areacode = areas.areacode ; LEFT OUTER JOIN spacead!campaign ON orders.campcode = campaigns.campcode ; WHERE Orders.job_no = ?cJobNo ; GROUP BY Orders.job_noThis will work. Note that the JOIN and ON clause are one statement. This is where the View Designer craps out.