SQL Help Please

[TeeSee]

tblMaterialMAster is the one side table, while tblCustomerItems is the
many side. The query wiz made up the SQl up to the WHERE word ...
that's where I inserted the WHERE clause and can't seem to get it
right. Trying to find the records in the one side that are blank.
Could someone set me straight please. Thanks

SELECT tblMaterialMaster.SISItemCode AS tblMaterialMaster_SISItemCode,
tblCustomerItems.SISItemCode AS tblCustomerItems_SISItemCode
FROM tblMaterialMaster WHERE tblMaterialMaster.SISItemCode =?????
RIGHT JOIN tblCustomerItems ON tblMaterialMaster.SISItemCode =
tblCustomerItems.SISItemCode;

 

[Ken Snell \(MVP\)]

SELECT tblMaterialMaster.SISItemCode AS tblMaterialMaster_SISItemCode,
tblCustomerItems.SISItemCode AS tblCustomerItems_SISItemCode
FROM tblMaterialMaster RIGHT JOIN tblCustomerItems ON
tblMaterialMaster.SISItemCode =
tblCustomerItems.SISItemCode
WHERE tblCustomerItems.SISItemCode =????? AND
tblMaterialMaster.SISItemCode Is Null;