Query Help - Joins are KILLING ME!

[tyleri]

Ok - I have some joins that are really causing me problems -I'm pretty new to SQL and I am learning as I am going along.

I have this much so far, and this is correct and I do not wish to change the way that *this* is structured:

FROM
vw_olp_userdetail
INNER JOIN
Business_Services_Provider
ON vw_olp_userdetail.login_id = Business_Services_Provider.login_id
INNER JOIN
DPS_USER
ON Business_Services_Provider.uid_id = DPS_USER.login_id

I was wondering if someone would kindly put this together for me so I can see how it is done, and most importantly--Get this project up and running!

Here is what the code above is joined to:

vw_olp_userdetail.login_id = business_services_provider_login_id

business_services_provider_uid_id = DPS_USER.login_id

Now that we have that query - (i need to include all those records and only the ones from the following tables that match up) for these joins below:

DPS_USER.ID = Contact_Info.ID
DPS_USER.ID = Pers_Fin_Info.id
DPS_USER.ID = Bus_Fin_Info.id
UniqueID.unique_id_cd = DPS_USER.unique_id_cd

THanks - I appreciate any help at all

 

[tyleri]

HEY! Don't bother, I figured it out! Thanks for anyone who tried to work with it though,

Tyelr