SQL retrieval

[EMILYTAN via AccessMonster.com]

How to select out the I_Available quantity to be placed in the qryOld as the
partnumber....?


mySQL5 = "SELECT qryOld.PartNumber FROM ([SELECT Incoming.PartNumber,
I_AvailableQty FROM Incoming WHERE Incoming.I_DespatchNote_Invoice='" & strMO
& "']. as qryOld) LEFT JOIN ([SELECT WIPRawDetails.PartNumber FROM
WIPRawDetails WHERE WIPRawDetails.JobNumber='" & strJobNumber & "' ]. as
qryNew) ON qryNew.PartNumber = qryOld.PartNumber WHERE (((qryNew.PartNumber)
Is Null)) "

myrecset5.Open mySQL5