Hi

I have the following Select:

SELECT Referral.*;
  FROM Referral;
 INNER JOIN Client;
    ON Referral.Cl_Ref = Client.Cl_Ref;
  LEFT OUTER JOIN Allocation;
    ON Client.Cl_Ref = Allocation.Cl_Ref;
 INNER JOIN Resource;
    ON Allocation.Rs_Ref = Resource.Rs_Ref;
 WHERE BETWEEN(Referral.Re_Date, ldStartDate, ldEndDate);
  INTO CURSOR Results

Now, my question is : Will the 2nd Inner Join restrict the results if there is no RESOURCE record relating to the ALLOCATION record. What I want to is for it to still retrieve the REFERRAL records, even if there is no related record between RESOURCE & ALLOCATION, because I'm only LEFT Joining the ALLOCATION.

The solution is simple, change the INNER to a LEFT OUTER, so basically, I'm just confirming what my thoughts are.

Any ideas?
Thanks
Kev