-
Sep 15th, 2017, 12:14 PM
#1
Thread Starter
Fanatic Member
-
Sep 15th, 2017, 01:15 PM
#2
Re: Junction tables and queries.
One thing I noticed,
Code:
INNER JOIN tblItemMaster ON tblItemMaster.intSiTech = lnkItemVendor.intSiTechItemID)
INNER JOIN tblSourceMaster ON tblSourceMaster.intSiTech = lnkItemVendor.intSiTechVendorID)
I didn't see intSiTech list in either the tblItemMaster or tblSourceMaster
-
Sep 15th, 2017, 01:23 PM
#3
Thread Starter
Fanatic Member
Re: Junction tables and queries.
Yeah, I was caught in error yet again (sheepish face imoge). To be fair I am somewhat dyslexic and it took me a really, really long time to find the problem. In the two lines of the of the join you have there I finally saw what was missing. In the ON parameters I had .intSiTech and they should have been .intSiTechID.
Thanks for the catch. I have been working on this since yesterday morning and could not, for the life of me, see the error in the parameters. I have been running the query since changing that and it provides exactly what I was after.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|