SELECT Components.Field1, Components.Field2, Components.Field3, Components.Field4, Components.Field5
FROM Components
WHERE Components.PartNumber = 'abc123';
This is the SQL that defines QueryA. It will return the row corresponding to abc123. This part number has content in Fields1-3 but not 4...