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
- jim durkin
"The universe is a big place, perhaps the biggest." Kurt Vonnegut