How do I get all records from left join in this Select -

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How do I get all records from left join in this Select -

Message

From

05/04/2000 10:03:12

Philip Pastor
Brulant, Inc.
Cleveland, Ohio, United States

05/04/2000 09:56:01

James Durkin
Randolph, New Jersey, United States

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: How do I get all records from left join in this Select -

Miscellaneous

Thread ID:

00355646

Message ID:

00355650

Views:

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

Map

View

Click here to load this message in the networking platform