Left join problem while translating from SQL to MSaccess

[cocteau]

I wrote query for SQL database, which works as it should, and have problem with "translation" into MSaccess, in "left join" part. The thing is that I placed "OR" inside that join:

left join SDBT_Device 
		ON SDBT_Device.DEV_Unique = PDBT_FDEVAssembly.DeviceID 
		or SDBT_Device.Dev_Unique = PDBT_FDEV.DeviceID)

which MSAccess won't allow. Any ideas how can I fight with this?

Here is my whole sql query if needed:

select 
	MIN(SDBT_Device_ML.szDefText) AS szDefText, 
	MIN(SDBT_Device_ML.DEV_Memo) AS DEV_Memo, 
	MIN(SDBT_Device.DEV_CostGroup) AS CostGroup,
	MIN(SDBT_CostGroup_ML.Translation) AS CostGroupTranslation,
	MIN(SDBT_Device_ML.GAEB_ShortText) AS GAEB_ShortText, 
	MIN(SDBT_Device_ML.GAEB_LongText) AS GAEB_LongText, 
	MIN(PDBT_DWG_TRIC.ID_DemandPos) AS ID_DemandPos, 
	'Qty' = 	
	SUM(case 
		when PDBT_FDEVAssembly.DeviceID is null then PDBT_FDEV.FDEV_Qty
		else PDBT_FDEVAssembly.Quantity * PDBT_FDEV.FDEV_Qty 
		END),
	MIN(SDBT_DeviceUnit_ML.DevUnitName) as DEV_UnitID,
	MIN(SDBT_DevCommerce.DEV_Price) AS DEV_Price, 
        MIN(SDBT_Currency.Cur_Description) AS CurDesc,
	SDBT_Device.DEV_Unique
from
	(((((((((((((PDBT_Project
	inner join PDBT_Title
		on PDBT_Project.ID = PDBT_Title.ProjectID)
	inner join PDBT_ISP
		on PDBT_Title.ID = PDBT_ISP.TitleID)
	inner join PDBT_GEWERK
		on PDBT_ISP.ID = PDBT_GEWERK.IspID)
	inner join PDBT_Anlage
		on PDBT_GEWERK.ID = PDBT_Anlage.GewerkID)
	inner join PDBT_DWG_TRIC
		on PDBT_Anlage.ID = PDBT_DWG_TRIC.BL_Anlage_ID)
	inner join PDBT_FDEV
		on PDBT_DWG_TRIC.ID = PDBT_FDEV.ID_DWG)
	left join PDBT_FDEVAssembly
		on PDBT_FDEV.ID_FDEV = PDBT_FDEVAssembly.FDEV_ID)
	left join SDBT_Device 
		ON SDBT_Device.DEV_Unique = PDBT_FDEVAssembly.DeviceID 
		or SDBT_Device.Dev_Unique = PDBT_FDEV.DeviceID)
 	inner join SDBT_DevCommerce 
		ON SDBT_Device.DEV_Unique = SDBT_DevCommerce.SD_ID)
	inner join SDBT_Device_ML 
		ON SDBT_Device.DEV_Unique = SDBT_Device_ML.DEV_Unique)
	inner join SDBT_DeviceUnit_ML
                on SDBT_Device.DEV_UnitID = SDBT_DeviceUnit_ML.DevUnitID)
	inner join  SDBT_Currency
 		on SDBT_CURRENCY.CUR_ID = SDBT_DevCommerce.DEV_Pr_Currency)
	left join SDBT_CostGroup_ML 
		on  SDBT_CostGroup_ML.StringID = SDBT_Device.DEV_CostGroup)
where
PDBT_Anlage.ID = %d
and 
((SDBT_Device_ML.LA_ID Is Not Null AND PDBT_Project.P_Language=[SDBT_Device_ML].[LA_ID])or (SDBT_Device_ML.LA_ID Is Null))
and
(SDBT_DeviceUnit_ML.LA_ID = PDBT_Project.P_Language)

GROUP BY SDBT_Device.DEV_Unique, SDBT_Device.DEV_CostGroup

ORDER BY SDBT_Device.DEV_CostGroup

('Qty' = SUM(case ... part is changed into iif(...) for MSAccess, everything else is just same)

SQL is SQL Server 2005, and access is MSAccess 2002.

[Alsvha]

My guess without parsing the entire thing through - you have a problem with your parenthesis. You do have a lot of them.
Properly the OR is interpreted wrong due to them.

I would advice you to try and fragment the query - remove the group by for starters and simply select * from two tables, and then keep adding a table until it goes wrong.