asked on

SQL Syntax Part III

I'm back again! I can't figure this one out for the life of me. I need to convert the FROM statement from Access to SQL. The more tables there are, the more confusing it is for me. Any help would be greatly appreciated. This is the FROM statement in Access.....

FROM ((dbo_somast INNER JOIN qrySOITEM ON dbo_somast.fsono = qrySOITEM.fsono) INNER JOIN qrySORELS ON (qrySOITEM.finumberA = qrySORELS.finumberA) AND (qrySOITEM.fsono = qrySORELS.fsono)) LEFT JOIN (qryJOITEM LEFT JOIN dbo_jodbom ON qryJOITEM.fjobno = dbo_jodbom.fjobno) ON (qrySORELS.fsono = qryJOITEM.fsono) AND (qrySORELS.finumberA = qryJOITEM.finumberA) AND (qrySORELS.frelease = qryJOITEM.fkey)

Open in new window

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vitor Montalvão

Sorry Jim, only after submit I saw that you've answered already.

Lawrence Salvucci

ASKER

Thank you both for your quick responses. I already printed that article you mentioned, Jim. I'm reading through it and learning as I go. Just certain parts that I still struggle with and the FROM statements is like a thorn in my side when there's multiple tables. Thank you again for your guidance!

Jim Horn

Do me a favor and send me a message with the areas were the article doesn't cover what you have to learn, and I'll make a revision to the article addressing them.

I need to go in there anyways as an EE upgrade about six months ago affected the image rendering in articles, and looks like I need to make some cosmetic changes.

Thanks for the grade, good luck with your project. -Jim

Lawrence Salvucci

ASKER

Will do Jim. I will message you in a few.