41 Problem with multiple left joins in rad 9.2

Questions PHPRad Classic
1

Hi

I have “partners” and “partners2”

image
image978×534 20.3 KB

But the “View_Driver” view only shows “partners”. It doesn’t show “partners2”.

image
image333×508 5.64 KB

I need to be able to make this query:

SELECT * FROM Services
LEFT JOIN Partners ON services.customer_partner_id=partners.id
LEFT JOIN Partners AS Partners2 ON services.driver_partner_id=Partners2.id

To show:
partners.company_name
and
partners2.last_name

I tried configuring it from the field properties, but it always assumes a relationship with “partners”. Is there an automated way to do this in RAD9.2, or does it have to be coded manually?

Any suggestions?

Thanks

Regards