Conerting MS Access query to SQL

[sqlnew123]

Hello,

I am trying to convert the following Access query to SQL. I am not sure about the multiple INNER JOINS. Can you help please?

SELECT dbo_ManagedRela tionshipBooks.S hortAlias AS Account, dbo_Portfolios. PortfolioID, dbo_Portfolios. ProductID, dbo_MainManaged Relationships.I sTaxAware INTO Portfolios
FROM (dbo_GO_Product s INNER JOIN ((((dbo_Managed RelationshipBoo ks INNER JOIN dbo_Relationshi pPortfolioMix ON dbo_ManagedRela tionshipBooks.R elationshipID = dbo_Relationshi pPortfolioMix.R elationshipID) INNER JOIN dbo_PortfolioAc countMix ON dbo_Relationshi pPortfolioMix.P ortfolioID = dbo_PortfolioAc countMix.Portfo lioID) INNER JOIN dbo_Portfolios ON dbo_Relationshi pPortfolioMix.P ortfolioID = dbo_Portfolios. PortfolioID) INNER JOIN dbo_Accounts ON dbo_PortfolioAc countMix.Accoun tID = dbo_Accounts.Ac countID) ON dbo_GO_Products .ProductID = dbo_Portfolios. ProductID) INNER JOIN dbo_MainManaged Relationships ON dbo_ManagedRela tionshipBooks.M ainRelationship ID = dbo_MainManaged Relationships.R elationshipID
WHERE (((dbo_GO_Produ cts.ParentProdu ctID) In (10029,10030,11 026)) AND ((dbo_ManagedRe lationshipBooks .Status)=1))
ORDER BY dbo_ManagedRela tionshipBooks.S hortAlias;


The SQL query would be:

SELECT Account = ManagedRelation shipBooks.Short Alias
, dbo_Portfolios. PortfolioID
, Portfolios.Prod uctID
, MainManagedRela tionships.IsTax Aware
INTO #Portfolios
FROM GO_Products
INNER JOIN ManagedRelation shipBooks
ON
(INNER JOIN dbo_Relationshi pPortfolioMix
ON ManagedRelation shipBooks.Relat ionshipID = RelationshipPor tfolioMix.Relat ionshipID
INNER JOIN PortfolioAccoun tMix
ON RelationshipPor tfolioMix.Portf olioID = PortfolioAccoun tMix.PortfolioI D
INNER JOIN Portfolios
ON RelationshipPor tfolioMix.Portf olioID = Portfolios.Port folioID
INNER JOIN Accounts
ON PortfolioAccoun tMix.AccountID = Accounts.Accoun tID,
ON GO_Products.Pro ductID = Portfolios.Prod uctID
INNER JOIN MainManagedRela tionships
ON ManagedRelation shipBooks.MainR elationshipID = MainManagedRela tionships.Relat ionshipID)
WHERE GO_Products.Par entProductID In (10029,10030,11 026)
AND ManagedRelation shipBooks.Statu s=1
ORDER BY ManagedRelation shipBooks.Short Alias


Thanks sqlnew123

[dorinbogdan]

SELECT ManagedRelationshipBooks.ShortAlias as Account, dbo_Portfolios.PortfolioID, Portfolios.ProductID, MainManagedRelationships.IsTaxAware 
INTO #Portfolios
FROM (GO_Products 
INNER JOIN 
((((ManagedRelationshipBooks 
INNER JOIN RelationshipPortfolioMix ON ManagedRelationshipBooks.RelationshipID = RelationshipPortfolioMix.RelationshipID) 
INNER JOIN PortfolioAccountMix ON RelationshipPortfolioMix.PortfolioID = PortfolioAccountMix.PortfolioID) 
INNER JOIN Portfolios ON RelationshipPortfolioMix.PortfolioID = Portfolios.PortfolioID) 
INNER JOIN Accounts ON PortfolioAccountMix.AccountID = Accounts.AccountID) 
ON GO_Products.ProductID = Portfolios.ProductID) 
INNER JOIN MainManagedRelationships ON ManagedRelationshipBooks.MainRelationshipID = MainManagedRelationships.RelationshipID
WHERE GO_Products.ParentProductID In (10029,10030,11026)
AND ManagedRelationshipBooks.Status=1
ORDER BY ManagedRelationshipBooks.ShortAlias