>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_no >