>James,
>
>I think you can change that to a RIGHT JOIN
>
>Hope this helps,
>
>
>
All
>When I run this SELECT command it only returns two records.
>The left table Servcalls has many records and I want to return all of them in a view. The right table Customers is the parent in a one to many relation with servcalls.
>
>Thanks in advance for your help!
>
>CREATE SQL VIEW CALLBACK AS ;
>SELECT ALL Servcalls.*, Customers.company;
>FROM appdata!servcalls LEFT JOIN appdata!customers ;
>ON Servcalls.prim_key = Customers.prim_key ;
>GROUP BY Servcalls.prim_key;
>ORDER BY Servcalls.callbacktime Thanks Philip,
I tried it with RIGHT JOIN and got one additional record with
all NULLS in the servcalls fields and a Company name with a non-matching prim_key.
I've tried every join combination using the View Wizard and Programacticly.
Nothing seems to work and this should be at the SQL 101 level.
Any other ideas would be appreciated,
Thanks Again,
Curtis (I work for Jim)
- jim durkin
"The universe is a big place, perhaps the biggest." Kurt Vonnegut