Welcome to the AutoNet Classified Ads. No records matched SELECT DISTINCT classifiedVehicles.SearchMake FROM classifiedVehicles,classifiedAccounts WHERE classifiedVehicles.DealerID = classifiedAccounts.DealerID AND classifiedAccounts.State='' ORDER BY classifiedVehicles.SearchMake So cannot make table...