# 41 Problem with multiple left joins in rad 9.2

**URL:** <https://forum.radsystems.io/t/41-problem-with-multiple-left-joins-in-rad-9-2/2925>\
**Category:** PHPRad Classic\
**Created:** [May 19, 2026, 2:57am UTC](https://forum.radsystems.io/t/41-problem-with-multiple-left-joins-in-rad-9-2/2925 "2026-05-19T02:57:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rha](https://forum.radsystems.io/letter_avatar_proxy/v4/letter/r/cdc98d/32.png) [@rha](https://forum.radsystems.io/u/rha)\
**Post date:** [May 19, 2026, 2:57am UTC](https://forum.radsystems.io/t/41-problem-with-multiple-left-joins-in-rad-9-2/2925/1 "2026-05-19T02:57:23Z")

</div>

Hi

I have “partners” and “partners2”

 ![image](https://forum.radsystems.io/uploads/default/original/2X/8/8b6eefec6b124e53376b77b55883ac580491fc08.png)

But the “View\_Driver” view only shows “partners”. It doesn’t show “partners2”.

 ![image](https://forum.radsystems.io/uploads/default/original/2X/d/d8ba600e6c25fbf488a02b5d658692de5758f3fb.png)

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
