Hi Naomi,

Sorry for the unclear description. I could probably try the JOIN on this select statement and the next select statement. I will try that. This first SELECT statement only looks for the PartNum if present; the second one is the main SELECT statement to gather the data.

Thanks,
Sam