37 : SELECT Providers.*
38 : FROM Providers INNER JOIN ProviderZipCodes ON Providers.providerNum = ProviderZipCodes.providerNum
39 : WHERE ProviderZipCodes.Zip like '#Form.Zip#' AND Providers.providerNum <> '11111' AND Providers.providerNum <> '22222' AND Providers.providerNum <> '33333'
40 : ORDER BY progName;
41 : </cfquery>
|