Posted by MGFoster on 10/26/06 06:39

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SELECT State, City
FROM table_name
WHERE Primary_Contact<>'y'
GROUP BY State, City

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRUBYA4echKqOuFEgEQLJTACgsOAgruNlQX254w4Abe/ychTn9IAAn11t
O+xXdFBxIeubcPHE0uh6fyoi
=YNNo
-----END PGP SIGNATURE-----


foneguy2 wrote:
> I have a table with 4 relevant fields (blank lines added for clarity).
> State, City, Name, Primary_Contact
> IL, Springfield, Bill, n
> IL, Springfield, Frank, n
> IL, Springfield, Larry, n
>
> IL, Bloomington, Steve, n
> IL, Bloomington, Chris, y
>
> IL, Chicago, Betty, n
> IL, Chicago, Linda, n
> IL, Chicago, Sue, n
>
> I need a query to return the state and cities that don't have a
> Primary_Contact='y'
> So the results would be:
> IL, Springfield
> IL, Chicago
>
> That's it. Any help is greatly appreciated.
>

[Back to original message]