Bingo! Thanks John! I guess I need to brush up on my SQL more. Again, thanks again, and again, and again, etc.

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