We help IT Professionals succeed at work.
Get Started

Cannot enter value into blank field on 'one' side of outer join

goingolfn99
goingolfn99 asked
on
789 Views
Last Modified: 2008-03-06
This may seem pretty easy but i'm bashing my head in right now. I'm cleaning up my database and it seemed to work in my previous version but I'm not able to add any data into my query. because of the statement "Cannot enter value into blank field on 'one' side of outer join" Can someone give me a quick fix and take a look at my sql query. I'm pretty sure its the way my tables are joined but I can't seem to figure out why it worked before. Thanks


SELECT PRODUCT_STOCKING_LOC_TIE.PRODUCT_BARCODE, PRODUCT_STOCKING_LOC_TIE.DESCRIPTION, PRODUCT_STOCKING_LOC_TIE.STOCKING_UOM AS UOM, PRODUCT_STOCKING_LOC_TIE.STOCKING_LOCATION_NAME AS LOCATION, tblMainDetail.QTY
FROM PRODUCT_MASTER RIGHT JOIN (PRODUCT_STOCKING_LOC_TIE LEFT JOIN tblMainDetail ON PRODUCT_STOCKING_LOC_TIE.ID = tblMainDetail.ID) ON PRODUCT_MASTER.PRODUCT_BARCODE = PRODUCT_STOCKING_LOC_TIE.PRODUCT_BARCODE
WHERE (((PRODUCT_STOCKING_LOC_TIE.STOCKING_LOCATION_NAME)=[Forms]![frmMain]![STOCKING_LOCATION]));
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE