>O.K., I could accept that. Let me show you my view select and maybe you can see something I don't.
>
>CREATE VIEW vSOrders AS ;
>SELECT Orders.*, Pubs.pubname, Areas.clname, Campaign.campaign;
> FROM spacead!orders INNER JOIN spacead!pubs;
> INNER JOIN spacead!areas;
> LEFT OUTER JOIN spacead!campaign ;
> ON Orders.campcode = Campaign.campcode ;
> ON Orders.areacode = Areas.areacode ;
> ON Orders.pub_id = Pubs.pub_id;
> WHERE Orders.job_no = ?cJobNo;
> GROUP BY Orders.job_no
>
>TIA
>
>>One of the limitations of the view designer is that it has a tendency to flip out if you've got more than two tables in it. About the only way around this is to avoid using the view designer and just modify the view programaticly. As far as the problem with your current view, your SQL statement has some stuff in the wrong order somewhere.