John ---
Whoops. Sorry about the blank...here goes again
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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
