SELECT tblPart.PartNumber, tblBrand.Brand, tblType.Type, tblVehicleBrand.Brand, tblModel.Model FROM tblPart, tblBrand, tblType, tblVehicleBrand, tblModel WHERE tblPart.Brand = tblBrand.BrandID AND tblPart.Type = tblType.TypeID AND tblType.Type = "Something" AND tblPart.VehicleBrand = tblVehicleBrand.BrandID AND tblPart.Model = tblModel.ModelID
From tblPart, there are also VehicleBrand and Model fields that need to be fetched. This data is not present for all records. The SQL above therefore fetches only the records where VehicleBrand and Model are not empty. Is there any way to make the SQL statement fetch the records where VehicleBrand and Model are empty as well?
This post has been edited by AN1554: 29 April 2012 - 10:27 AM