MSQuery Multi-table LEFT Join won't work! Guru's, help!!

IMNovice

New Member
Joined
Jun 23, 2005
Messages
27
Is it possible to create a MSQuery to LEFT Join multiple tables? I keep getting a message that it can only do it on two tables. I can do it easily in MSAccess. Can I write it in SQL?

I have one table with Project#'s. Another table has Project#'s and Dept. Another table has Project#'s and Organization and another has Project#'s and Budget Centers.

I want all Project#'s from the first table to be retrieved and any related data from the other tables to be retrieved joined by Project#.

In Access, the SQL is:
SELECT NewUnbilledProjIdX.Proj_Id, PROJORG.Organization, [PROJBAC-all proj top].BAC, [PROJCUST-all proj, top lvl].[Cust Name]
FROM ((NewUnbilledProjIdX LEFT JOIN PROJORG ON NewUnbilledProjIdX.Proj_Id = PROJORG.Project) LEFT JOIN [PROJBAC-all proj top] ON NewUnbilledProjIdX.Proj_Id = [PROJBAC-all proj top].Project) LEFT JOIN [PROJCUST-all proj, top lvl] ON NewUnbilledProjIdX.Proj_Id = [PROJCUST-all proj, top lvl].Project;

Can this be converted so it can be run in MSQuery?

Thanks
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,224,926
Messages
6,181,792
Members
453,066
Latest member
Firemonte

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top