SQL Zen Garden

View ColdFusion Source code

This example will show a FULL OUTER JOIN.
It shows the city names that are common between New York and New Jersey.
It uses the coalesce function to sort by cityname.
Notice that Andover is common between the two states.
See SQL Zen Garden 012 for an intersect query.

State	City	City	State
		Absecon	New Jersey
New York	Adams
New York	Adams Center
New York	Addison
New York	Afton
New York	Airmont
New York	Akron
New York	Albany
New York	Albertson
New York	Albion
New York	Alden
New York	Alexander
New York	Alexandria Bay
New York	Alfred
		Allamuchy-Panther Valley	New Jersey
New York	Allegany
		Allendale	New Jersey
		Allenhurst	New Jersey
		Allentown	New Jersey
		Alloway	New Jersey
New York	Almond
		Alpha	New Jersey
		Alpine	New Jersey
New York	Altamont
New York	Altmar
New York	Altona
New York	Amenia
New York	Ames
New York	Amityville
New York	Amsterdam
New York	Andes
New York	Andover	Andover	New Jersey
New York	Angelica
New York	Angola
New York	Angola on the Lake
		Annandale	New Jersey
New York	Antwerp
New York	Apalachin
New York	Aquebogue
New York	Arcade
New York	Ardsley
New York	Argyle
New York	Arkport
New York	Arlington
New York	Armonk
		Asbury Park	New Jersey
New York	Asharoken
New York	Athens
New York	Atlantic Beach
		Atlantic City	New Jersey
		Atlantic Highlands	New Jersey
New York	Attica
New York	Auburn
		Audubon	New Jersey
		Audubon Park	New Jersey
New York	Aurora
		Avalon	New Jersey
		Avenel	New Jersey
New York	Averill Park
New York	Avoca
New York	Avon
		Avon-by-the-Sea	New Jersey
New York	Babylon
New York	Bainbridge
New York	Baldwin
New York	Baldwin Harbor
New York	Baldwinsville
New York	Ballston Spa
New York	Balmville
New York	Bardonia
New York	Barker
		Barnegat	New Jersey
		Barnegat Light	New Jersey
New York	Barneveld
New York	Barnum Island
		Barrington	New Jersey
New York	Batavia
New York	Bath
New York	Baxter Estates
		Bay Head	New Jersey
New York	Bay Shore
		Bayonne	New Jersey
New York	Bayport
New York	Bayville
New York	Baywood
		Beach Haven	New Jersey
		Beach Haven West	New Jersey
		Beachwood	New Jersey
New York	Beacon
		Beattyestown	New Jersey
New York	Beaverdam Lake-Salisbury Mills
		Beckett	New Jersey
New York	Bedford
New York	Belle Terre
New York	Bellerose
		Belleville	New Jersey
		Bellmawr	New Jersey
New York	Bellmore
New York	Bellport
		Belmar	New Jersey
New York	Belmont
		Belvidere	New Jersey
New York	Bemus Point
New York	Bergen
		Bergenfield	New Jersey
		Berkeley Heights	New Jersey
		Berlin	New Jersey
		Bernardsville	New Jersey
New York	Bethpage
		Beverly	New Jersey
New York	Big Flats
New York	Big Flats Airport
New York	Billington Heights
New York	Binghamton
New York	Black River
		Blackwood	New Jersey
New York	Blasdell
New York	Blauvelt
		Bloomfield	New Jersey
New York	Bloomingburg
		Bloomingdale	New Jersey
		Bloomsbury	New Jersey
New York	Blue Point
		Bogota	New Jersey
New York	Bohemia
New York	Bolivar
		Boonton	New Jersey
New York	Boonville
		Bordentown	New Jersey
		Bound Brook	New Jersey
		Bradley Beach	New Jersey
		Branchville	New Jersey
New York	Brasher Falls-Winthrop
		Brass Castle	New Jersey
New York	Brentwood
New York	Brewerton
New York	Brewster
New York	Brewster Hill
New York	Briarcliff Manor
		Brick Township	New Jersey
New York	Bridgehampton
New York	Bridgeport
		Bridgeton	New Jersey
New York	Bridgewater
		Brielle	New Jersey
		Brigantine	New Jersey
New York	Brighton
New York	Brightwaters
New York	Brinckerhoff
New York	Broadalbin
New York	Brockport
New York	Brocton
New York	Bronxville
New York	Brookhaven
		Brooklawn	New Jersey
New York	Brookville
		Brown Mills	New Jersey
New York	Brownville
New York	Brushton
New York	Buchanan
		Budd Lake	New Jersey
		Buena	New Jersey
New York	Buffalo
New York	Burdett
New York	Burke
		Burlington	New Jersey
		Butler	New Jersey
New York	Cairo
New York	Calcium
		Caldwell	New Jersey
New York	Caledonia
		Califon	New Jersey
New York	Calverton
New York	Cambridge
New York	Camden	Camden	New Jersey
New York	Camillus
New York	Canajoharie
New York	Canandaigua
New York	Canaseraga
New York	Canastota
New York	Candor
New York	Canisteo
New York	Canton
		Cape May	New Jersey
		Cape May Court House	New Jersey
		Cape May Point	New Jersey
New York	Cape Vincent
New York	Carle Place
		Carlstadt	New Jersey
New York	Carmel Hamlet
		Carneys Point	New Jersey
		Carteret	New Jersey
New York	Carthage
New York	Cassadaga
New York	Castile
New York	Castleton-on-Hudson
New York	Castorland
New York	Cato
New York	Catskill
New York	Cattaraugus
New York	Cayuga
New York	Cayuga Heights
New York	Cazenovia
		Cedar Glen Lakes	New Jersey
		Cedar Glen West	New Jersey
		Cedar Grove	New Jersey
New York	Cedarhurst
New York	Celoron
New York	Center Moriches
New York	Centereach
New York	Centerport
New York	Central Islip
New York	Central Square
New York	Central Valley
New York	Centre Island
New York	Champlain
New York	Chateaugay
New York	Chatham	Chatham	New Jersey
New York	Chaumont
New York	Cheektowaga
New York	Cherry Creek
		Cherry Hill	New Jersey
New York	Cherry Valley
		Chesilhurst	New Jersey
New York	Chester	Chester	New Jersey
New York	Chestnut Ridge
New York	Chittenango
New York	Churchville
		Cinnaminson	New Jersey
New York	Clarence Center
		Clark	New Jersey
New York	Clark Mills
New York	Claverack-Red Mills
New York	Clayton	Clayton	New Jersey
New York	Clayville
		Clearbrook Park	New Jersey
		Clementon	New Jersey
New York	Cleveland
		Cliffside Park	New Jersey
		Cliffwood Beach	New Jersey
		Clifton	New Jersey
New York	Clifton Springs
New York	Clinton	Clinton	New Jersey
New York	Clintondale
		Closter	New Jersey
New York	Clyde
New York	Cobleskill
New York	Cohocton
New York	Cohoes
New York	Cold Brook
New York	Cold Spring
New York	Cold Spring Harbor
		Collings Lakes	New Jersey
		Collingswood	New Jersey
		Colonia	New Jersey
New York	Colonie
New York	Commack
		Concordia	New Jersey
New York	Congers
New York	Constableville
New York	Constantia
New York	Cooperstown
New York	Copenhagen
New York	Copiague
New York	Coram
		Corbin City	New Jersey
New York	Corfu
New York	Corinth
New York	Corning
New York	Cornwall on Hudson
New York	Cortland
New York	Cortland West
New York	Country Knolls
		Country Lake Estates	New Jersey
New York	Cove Neck
New York	Coxsackie
		Crandon Lakes	New Jersey
		Cranford	New Jersey
		Cresskill	New Jersey
		Crestwood Village	New Jersey
New York	Croghan
New York	Croton-on-Hudson
New York	Crown Heights
New York	Cuba
New York	Cumberland Head
New York	Cutchogue
New York	Dannemora
New York	Dansville
		Dayton	New Jersey
New York	De Witt
		Deal	New Jersey
New York	Deer Park
New York	Deferiet
		Delanco	New Jersey
New York	Delanson
New York	Delevan
New York	Delhi
New York	Delmar
		Demarest	New Jersey
New York	Depew
New York	Deposit
New York	Dering Harbor
New York	Deruyter
New York	Dexter
New York	Dix Hills
New York	Dobbs Ferry
New York	Dolgeville
		Dover	New Jersey
New York	Dover Plains
New York	Dresden
New York	Dryden
		Dumont	New Jersey
New York	Dundee
		Dunellen	New Jersey
New York	Dunkirk
New York	Earlville
New York	East Aurora
New York	East Bloomfield
		East Brunswick	New Jersey
New York	East Farmingdale
		East Freehold	New Jersey
New York	East Glenville
New York	East Greenbush
New York	East Hampton
New York	East Hampton North
		East Hanover	New Jersey
New York	East Hills
New York	East Islip
New York	East Ithaca
New York	East Massapequa
New York	East Meadow
New York	East Middletown
New York	East Moriches
		East Newark	New Jersey
New York	East Northport
New York	East Norwich
		East Orange	New Jersey
New York	East Patchogue
New York	East Quogue
New York	East Randolph
New York	East Rochester
New York	East Rockaway
		East Rutherford	New Jersey
New York	East Shoreham
New York	East Syracuse
New York	East Williston
New York	Eastchester
New York	Eatons Neck
		Eatontown	New Jersey
New York	Eden
		Edgewater	New Jersey
		Edgewater Park	New Jersey
		Edison	New Jersey
New York	Edwards
		Egg Harbor City	New Jersey
New York	Elba
New York	Elbridge
		Elizabeth	New Jersey
New York	Ellenville
New York	Ellicottville
New York	Ellisburg
New York	Elma Center
		Elmer	New Jersey
New York	Elmira
New York	Elmira Heights
New York	Elmont
New York	Elmsford
		Elmwood Park	New Jersey
New York	Elwood
		Elwood-Magnolia	New Jersey
		Emerson	New Jersey
New York	Endicott
New York	Endwell
		Englewood	New Jersey
		Englewood Cliffs	New Jersey
		Englishtown	New Jersey
		Erma	New Jersey
New York	Esperance
		Estell Manor	New Jersey
New York	Evans Mills
		Ewing	New Jersey
New York	Fabius
New York	Fair Haven	Fair Haven	New Jersey
		Fair Lawn	New Jersey
		Fairfield	New Jersey
New York	Fairmount
New York	Fairport
		Fairton	New Jersey
New York	Fairview	Fairview	New Jersey
New York	Fairview	Fairview	New Jersey
New York	Falconer
		Fanwood	New Jersey
		Far Hills	New Jersey
New York	Farmingdale	Farmingdale	New Jersey
New York	Farmingville
New York	Farnham
New York	Fayetteville
		Fieldsboro	New Jersey
New York	Fillmore
New York	Firthcliffe
New York	Fishkill
New York	Flanders
New York	Fleischmanns
		Flemington	New Jersey
New York	Floral Park
		Florence-Roebling	New Jersey
		Florham Park	New Jersey
New York	Florida
New York	Flower Hill
		Folsom	New Jersey
New York	Fonda
		Fords	New Jersey
New York	Forest Home
New York	Forestville
		Forked River	New Jersey
New York	Fort Ann
		Fort Dix	New Jersey
New York	Fort Drum
New York	Fort Edward
New York	Fort Johnson
		Fort Lee	New Jersey
New York	Fort Montgomery
New York	Fort Plain
New York	Fort Salonga
New York	Frankfort
New York	Franklin	Franklin	New Jersey
		Franklin Lakes	New Jersey
New York	Franklin Square
New York	Franklinville
New York	Fredonia
		Freehold	New Jersey
New York	Freeport
New York	Freeville
		Frenchtown	New Jersey
New York	Frewsburg
New York	Friendship
New York	Fulton
New York	Fultonville
New York	Gainesville
New York	Galway
New York	Gang Mills
New York	Garden City
New York	Garden City Park
New York	Garden City South
New York	Gardnertown
		Garfield	New Jersey
		Garwood	New Jersey
New York	Gasport
New York	Gates-North Gates
New York	Geneseo
New York	Geneva
		Gibbsboro	New Jersey
		Gibbstown	New Jersey
New York	Gilbertsville
		Gilford Park	New Jersey
New York	Glasco
		Glassboro	New Jersey
New York	Glen Cove
		Glen Gardner	New Jersey
New York	Glen Head
New York	Glen Park
		Glen Ridge	New Jersey
		Glen Rock	New Jersey
		Glendora	New Jersey
New York	Glens Falls
New York	Glens Falls North
New York	Glenwood Landing
		Gloucester City	New Jersey
New York	Gloversville
New York	Golden's Bridge
New York	Goshen
New York	Gouverneur
New York	Gowanda
New York	Grand View-on-Hudson
New York	Granville
		Great Meadows-Vienna	New Jersey
New York	Great Neck
New York	Great Neck Estates
New York	Great Neck Plaza
New York	Greece
New York	Green Island
New York	Greene
New York	Greenlawn
New York	Greenport
New York	Greenport West
New York	Greenville
New York	Greenwich
New York	Greenwood Lake
New York	Groton
		Guttenberg	New Jersey
		Hackensack	New Jersey
		Hackettstown	New Jersey
		Haddon Heights	New Jersey
		Haddonfield	New Jersey
New York	Hagaman
		Haledon	New Jersey
New York	Halesite
New York	Hamburg	Hamburg	New Jersey
New York	Hamilton
New York	Hammond
New York	Hammondsport
		Hammonton	New Jersey
		Hampton	New Jersey
New York	Hampton Bays
New York	Hampton Manor
New York	Hancock
New York	Hannibal
		Hanover Township	New Jersey
New York	Harriman
		Harrington Park	New Jersey
New York	Harris Hill
New York	Harrison	Harrison	New Jersey
New York	Harrisville
New York	Hartsdale
		Harvey Cedars	New Jersey
		Hasbrouck Heights	New Jersey
New York	Hastings-on-Hudson
New York	Hauppauge
New York	Haverstraw
New York	Haviland
		Haworth	New Jersey
New York	Hawthorne	Hawthorne	New Jersey
New York	Head of the Harbor
		Heathcote	New Jersey
		Helmetta	New Jersey
New York	Hempstead
New York	Herkimer
New York	Hermon
New York	Herricks
New York	Herrings
New York	Heuvelton
New York	Hewlett
New York	Hewlett Bay Park
New York	Hewlett Harbor
New York	Hewlett Neck
		Hi-Nella	New Jersey
New York	Hicksville
		High Bridge	New Jersey
New York	Highland
New York	Highland Falls
		Highland Lake	New Jersey
New York	Highland Mills
		Highland Park	New Jersey
		Highlands	New Jersey
		Hightstown	New Jersey
New York	Hillburn
New York	Hillcrest
		Hillsdale	New Jersey
		Hillside	New Jersey
New York	Hillside Lake
New York	Hilton
		Ho-Ho-Kus	New Jersey
New York	Hobart
		Hoboken	New Jersey
New York	Holbrook
New York	Holcomb
		Holiday City South	New Jersey
		Holiday City-Berkeley	New Jersey
		Holiday City-Dover	New Jersey
		Holiday Heights	New Jersey
New York	Holland
New York	Holland Patent
New York	Holley
New York	Holtsville
New York	Homer
New York	Honeoye Falls
New York	Hoosick Falls
		Hopatcong	New Jersey
		Hopewell	New Jersey
New York	Hopewell Junction
New York	Hornell
New York	Horseheads
New York	Horseheads North
New York	Houghton
New York	Hudson
New York	Hudson Falls
New York	Hunter
New York	Huntington
New York	Huntington Bay
New York	Huntington Station
New York	Hurley
New York	Ilion
New York	Interlaken	Interlaken	New Jersey
New York	Inwood
New York	Irondequoit
New York	Irvington	Irvington	New Jersey
		Iselin	New Jersey
		Island Heights	New Jersey
New York	Island Park
New York	Islandia
New York	Islip
New York	Islip Terrace
New York	Ithaca
		Jamesburg	New Jersey
New York	Jamesport
New York	Jamestown
New York	Jamestown West
New York	Jefferson Heights
New York	Jefferson Valley-Yorktown
New York	Jeffersonville
New York	Jericho
		Jersey City	New Jersey
New York	Johnson City
New York	Johnstown
New York	Jordan
		Keansburg	New Jersey
		Kearny	New Jersey
New York	Keeseville
		Kendall Park	New Jersey
		Kenilworth	New Jersey
New York	Kenmore
New York	Kensington
New York	Kerhonkson
		Keyport	New Jersey
New York	Kinderhook
New York	Kings Park
New York	Kings Point
New York	Kingston	Kingston	New Jersey
		Kinnelon	New Jersey
New York	Kiryas Joel
New York	Lackawanna
New York	Lacona
New York	Lake Carmel
New York	Lake Erie Beach
New York	Lake George
New York	Lake Grove
New York	Lake Katrine
New York	Lake Luzerne-Hadley
		Lake Mohawk	New Jersey
New York	Lake Placid
New York	Lake Ronkonkoma
New York	Lake Success
		Lake Telemark	New Jersey
		Lakehurst	New Jersey
New York	Lakeview
New York	Lakewood	Lakewood	New Jersey
		Lambertville	New Jersey
New York	Lancaster
New York	Lansing
New York	Larchmont
New York	Latham
New York	Lattingtown
New York	Laurel
New York	Laurel Hollow
		Laurel Springs	New Jersey
		Laurence Harbor	New Jersey
New York	Laurens
		Lavallette	New Jersey
		Lawnside	New Jersey
New York	Lawrence
		Lawrenceville	New Jersey
New York	Le Roy
		Lebanon	New Jersey
New York	Leicester
		Leisure Knoll	New Jersey
		Leisure Village	New Jersey
		Leisure Village East	New Jersey
		Leisure Village West-Pine Lake Park	New Jersey
		Leisuretowne	New Jersey
		Leonardo	New Jersey
		Leonia	New Jersey
New York	Levittown
New York	Lewiston
New York	Liberty
New York	Lido Beach
New York	Lima
New York	Lime Lake-Machias
New York	Limestone
New York	Lincoln Park	Lincoln Park	New Jersey
		Lincroft	New Jersey
		Linden	New Jersey
New York	Lindenhurst
		Lindenwold	New Jersey
		Linwood	New Jersey
New York	Lisle
New York	Little Falls	Little Falls	New Jersey
		Little Ferry	New Jersey
		Little Silver	New Jersey
New York	Little Valley
New York	Liverpool
		Livingston	New Jersey
New York	Livingston Manor
New York	Livonia
New York	Lloyd Harbor
		Loch Arbour	New Jersey
New York	Lockport
New York	Locust Valley
New York	Lodi	Lodi	New Jersey
New York	Long Beach
		Long Branch	New Jersey
		Long Valley	New Jersey
		Longport	New Jersey
New York	Lorenz Park
New York	Loudonville
New York	Lowville
New York	Lynbrook
New York	Lyncourt
		Lyndhurst	New Jersey
New York	Lyndon
New York	Lyndonville
New York	Lyons
New York	Lyons Falls
New York	Macedon
New York	Madison	Madison	New Jersey
		Madison Park	New Jersey
		Magnolia	New Jersey
New York	Mahopac
New York	Malone
New York	Malverne
New York	Mamaroneck
		Manahawkin	New Jersey
		Manasquan	New Jersey
New York	Manchester
New York	Manhasset
New York	Manhasset Hills
New York	Manlius
New York	Mannsville
New York	Manorhaven
New York	Manorville
		Mantoloking	New Jersey
		Manville	New Jersey
		Maple Shade	New Jersey
		Maplewood	New Jersey
New York	Marathon
New York	Marcellus
New York	Margaretville
		Margate City	New Jersey
New York	Marlboro
		Marlton	New Jersey
New York	Massapequa
New York	Massapequa Park
New York	Massena
New York	Mastic
New York	Mastic Beach
		Matawan	New Jersey
New York	Matinecock
New York	Mattituck
New York	Mattydale
New York	Maybrook
New York	Mayfield
		Mays Landing	New Jersey
New York	Mayville
		Maywood	New Jersey
New York	McGraw
		McGuire AFB	New Jersey
New York	Mechanicville
New York	Medford
		Medford Lakes	New Jersey
New York	Medina
New York	Melrose Park
New York	Melville
New York	Menands
		Mendham	New Jersey
		Mercerville-Hamilton Square	New Jersey
		Merchantville	New Jersey
New York	Meridian
New York	Merrick
		Metuchen	New Jersey
New York	Mexico
New York	Middle Island
New York	Middleburgh
New York	Middleport
		Middlesex	New Jersey
New York	Middletown
New York	Middleville
		Midland Park	New Jersey
New York	Milford	Milford	New Jersey
New York	Mill Neck
New York	Millbrook
		Millburn	New Jersey
New York	Miller Place
New York	Millerton
New York	Millport
		Millstone	New Jersey
		Milltown	New Jersey
		Millville	New Jersey
New York	Milton
New York	Milton
New York	Mineola
New York	Minetto
New York	Mineville-Witherbee
New York	Minoa
New York	Mohawk
		Monmouth Beach	New Jersey
		Monmouth Junction	New Jersey
New York	Monroe
New York	Monsey
New York	Montauk
		Montclair	New Jersey
New York	Montebello
New York	Montgomery
New York	Monticello
New York	Montour Falls
		Montvale	New Jersey
New York	Mooers
		Moonachie	New Jersey
		Moorestown-Lenola	New Jersey
New York	Moravia
New York	Morris
		Morris Plains	New Jersey
New York	Morrisonville
New York	Morristown	Morristown	New Jersey
New York	Morrisville
		Mount Arlington	New Jersey
		Mount Ephraim	New Jersey
		Mount Holly	New Jersey
New York	Mount Ivy
New York	Mount Kisco
New York	Mount Morris
New York	Mount Sinai
New York	Mount Vernon
		Mountain Lakes	New Jersey
		Mountainside	New Jersey
		Mullica Hill	New Jersey
New York	Munnsville
New York	Munsey Park
New York	Munsons Corners
New York	Muttontown
New York	Myers Corner
		Mystic Island	New Jersey
New York	Nanuet
New York	Napanoch
New York	Naples
New York	Nassau
		National Park	New Jersey
New York	Nelliston
New York	Nelsonville
		Neptune City	New Jersey
New York	Nesconset
		Netcong	New Jersey
New York	New Berlin
		New Brunswick	New Jersey
New York	New Cassel
New York	New City
		New Egypt	New Jersey
New York	New Hartford
New York	New Hempstead
New York	New Hyde Park
		New Milford	New Jersey
New York	New Paltz
		New Providence	New Jersey
New York	New Rochelle
New York	New Square
New York	New Windsor
New York	New York
New York	New York Mills
New York	Newark	Newark	New Jersey
New York	Newark Valley
New York	Newburgh
New York	Newfane
		Newfield	New Jersey
New York	Newfield Hamlet
New York	Newport
		Newton	New Jersey
New York	Niagara Falls
New York	Nichols
New York	Niskayuna
New York	Nissequogue
New York	Niverville
New York	Norfolk
New York	North Amityville
		North Arlington	New Jersey
New York	North Babylon
New York	North Ballston Spa
New York	North Bay Shore
		North Beach Haven	New Jersey
New York	North Bellmore
New York	North Bellport
		North Bergen	New Jersey
New York	North Boston
		North Brunswick Township	New Jersey
		North Caldwell	New Jersey
		North Cape May	New Jersey
New York	North Collins
New York	North Great River
		North Haledon	New Jersey
New York	North Haven
New York	North Hills
New York	North Hornell
New York	North Lindenhurst
New York	North Massapequa
New York	North Merrick
		North Middletown	New Jersey
New York	North New Hyde Park
New York	North Patchogue
		North Plainfield	New Jersey
New York	North Sea
New York	North Syracuse
New York	North Tarrytown
New York	North Tonawanda
New York	North Valley Stream
New York	North Wantagh
		North Wildwood	New Jersey
New York	Northeast Ithaca
		Northfield	New Jersey
New York	Northport
		Northvale	New Jersey
New York	Northville
New York	Northwest Harbor
New York	Northwest Ithaca
New York	Norwich
New York	Norwood	Norwood	New Jersey
New York	Noyack
New York	Nunda
		Nutley	New Jersey
New York	Nyack
		Oak Valley	New Jersey
New York	Oakdale
New York	Oakfield
		Oakhurst	New Jersey
		Oakland	New Jersey
		Oaklyn	New Jersey
		Ocean Acres	New Jersey
New York	Ocean Beach
		Ocean City	New Jersey
		Ocean Gate	New Jersey
		Ocean Grove	New Jersey
		Oceanport	New Jersey
New York	Oceanside
New York	Odessa
New York	Ogdensburg	Ogdensburg	New Jersey
New York	Olcott
New York	Old Bethpage
		Old Bridge	New Jersey
New York	Old Brookville
New York	Old Field
		Old Tappan	New Jersey
New York	Old Westbury
New York	Olean
		Olivet	New Jersey
New York	Oneida
New York	Oneida Castle
New York	Oneonta
		Oradell	New Jersey
		Orange	New Jersey
New York	Orange Lake
New York	Orangeburg
New York	Orchard Park
New York	Oriskany
New York	Oriskany Falls
New York	Ossining
New York	Oswego
New York	Otego
New York	Otisville
New York	Ovid
New York	Owego
New York	Oxford	Oxford	New Jersey
New York	Oyster Bay
New York	Oyster Bay Cove
New York	Painted Post
New York	Palatine Bridge
		Palisades Park	New Jersey
New York	Palmyra	Palmyra	New Jersey
New York	Panama
		Paramus	New Jersey
New York	Parish
		Park Ridge	New Jersey
		Parsippany-Troy Hills Township	New Jersey
		Passaic	New Jersey
New York	Patchogue
		Paterson	New Jersey
		Paulsboro	New Jersey
New York	Pawling
New York	Peach Lake
		Peapack and Gladstone	New Jersey
New York	Pearl River
New York	Peconic
New York	Peekskill
New York	Pelham
New York	Pelham Manor
		Pemberton	New Jersey
		Pemberton Heights	New Jersey
New York	Penn Yan
		Pennington	New Jersey
		Penns Grove	New Jersey
		Pennsauken	New Jersey
		Pennsville	New Jersey
		Pequannock Township	New Jersey
New York	Perry
New York	Perrysburg
		Perth Amboy	New Jersey
New York	Peru
New York	Phelps
New York	Philadelphia
		Phillipsburg	New Jersey
New York	Philmont
New York	Phoenix
New York	Piermont
New York	Pike
		Pine Beach	New Jersey
New York	Pine Bush
		Pine Hill	New Jersey
New York	Pine Plains
		Pine Ridge at Crestwood	New Jersey
New York	Pine Valley	Pine Valley	New Jersey
		Pitman	New Jersey
New York	Pittsford
New York	Plainedge
		Plainfield	New Jersey
New York	Plainview
New York	Plandome
New York	Plandome Heights
New York	Plandome Manor
New York	Plattsburgh
New York	Plattsburgh AFB
New York	Plattsburgh West
		Pleasant Plains	New Jersey
New York	Pleasant Valley
New York	Pleasantville	Pleasantville	New Jersey
New York	Poestenkill
		Point Pleasant	New Jersey
		Point Pleasant Beach	New Jersey
New York	Poland
New York	Pomona	Pomona	New Jersey
		Pompton Lakes	New Jersey
New York	Poquott
New York	Port Byron
New York	Port Chester
New York	Port Dickinson
New York	Port Ewen
New York	Port Henry
New York	Port Jefferson
New York	Port Jefferson Station
New York	Port Jervis
New York	Port Leyden
		Port Monmouth	New Jersey
		Port Norris	New Jersey
		Port Reading	New Jersey
		Port Republic	New Jersey
New York	Port Washington
New York	Port Washington North
New York	Portville
New York	Potsdam
New York	Poughkeepsie
		Presidential Lakes Estates	New Jersey
		Princeton	New Jersey
		Princeton Junction	New Jersey
		Princeton North	New Jersey
New York	Prospect
		Prospect Park	New Jersey
New York	Pulaski
New York	Putnam Lake
New York	Quogue
		Rahway	New Jersey
		Ramblewood	New Jersey
		Ramsey	New Jersey
New York	Randolph
New York	Ransomville
New York	Rapids
		Raritan	New Jersey
New York	Ravena
		Red Bank	New Jersey
New York	Red Creek
New York	Red Hook
New York	Red Oaks Mill
New York	Remsen
New York	Remsenburg-Speonk
New York	Rensselaer
New York	Rensselaer Falls
New York	Rhinebeck
New York	Richburg
New York	Richfield Springs
New York	Richmondville
New York	Richville
New York	Ridge
		Ridgefield	New Jersey
		Ridgefield Park	New Jersey
		Ridgewood	New Jersey
		Ringwood	New Jersey
		Rio Grande	New Jersey
New York	Ripley
		River Edge	New Jersey
		River Vale	New Jersey
		Riverdale	New Jersey
New York	Riverhead
New York	Riverside	Riverside	New Jersey
New York	Riverside	Riverside	New Jersey
		Riverton	New Jersey
		Robertsville	New Jersey
		Rochelle Park	New Jersey
New York	Rochester
		Rockaway	New Jersey
		Rockleigh	New Jersey
New York	Rockville Centre
		Rocky Hill	New Jersey
New York	Rocky Point
New York	Roessleville
New York	Rome
New York	Ronkonkoma
New York	Roosevelt	Roosevelt	New Jersey
		Roseland	New Jersey
		Roselle	New Jersey
		Roselle Park	New Jersey
New York	Rosendale Village
		Rosenhayn	New Jersey
New York	Roslyn
New York	Roslyn Estates
New York	Roslyn Harbor
New York	Roslyn Heights
		Rossmoor	New Jersey
New York	Rotterdam
New York	Round Lake
New York	Rouses Point
		Rumson	New Jersey
		Runnemede	New Jersey
New York	Rushville
New York	Russell Gardens
		Rutherford	New Jersey
New York	Rye
New York	Rye Brook
New York	Sackets Harbor
		Saddle Brook	New Jersey
		Saddle River	New Jersey
New York	Saddle Rock
New York	Sag Harbor
New York	Salamanca
New York	Salem	Salem	New Jersey
New York	Salisbury
New York	Saltaire
New York	Sand Ridge
New York	Sands Point
New York	Sandy Creek
New York	Saranac Lake
New York	Saratoga Springs
New York	Saugerties
New York	Saugerties South
New York	Savona
		Sayreville	New Jersey
New York	Sayville
New York	Scarsdale
New York	Schaghticoke
New York	Schenectady
New York	Schenevus
New York	Schoharie
New York	Schuylerville
		Scotch Plains	New Jersey
New York	Scotchtown
New York	Scotia
New York	Scottsville
		Sea Bright	New Jersey
New York	Sea Cliff
		Sea Girt	New Jersey
		Sea Isle City	New Jersey
		Seabrook Farms	New Jersey
New York	Seaford
New York	Searingtown
		Seaside Heights	New Jersey
		Seaside Park	New Jersey
		Secaucus	New Jersey
New York	Selden
New York	Seneca Falls
New York	Setauket-East Setauket
		Sewaren	New Jersey
		Shark River Hills	New Jersey
New York	Sharon Springs
New York	Shelter Island
New York	Shelter Island Heights
New York	Sherburne
New York	Sherman
New York	Sherrill
		Shiloh	New Jersey
New York	Shinnecock Hills
		Ship Bottom	New Jersey
New York	Shirley
New York	Shoreham
New York	Shortsville
		Shrewsbury	New Jersey
New York	Sidney
New York	Silver Creek
		Silver Ridge	New Jersey
New York	Silver Springs
		Silverton	New Jersey
New York	Sinclairville
New York	Skaneateles
New York	Sloan
New York	Sloatsburg
New York	Smithtown
New York	Smyrna
		Society Hill	New Jersey
New York	Sodus
New York	Sodus Point
New York	Solvay
		Somerdale	New Jersey
		Somers Point	New Jersey
		Somerset	New Jersey
		Somerville	New Jersey
New York	Sound Beach
		South Amboy	New Jersey
		South Belmar	New Jersey
		South Bound Brook	New Jersey
New York	South Corning
New York	South Dayton
New York	South Fallsburg
New York	South Farmingdale
New York	South Floral Park
New York	South Glens Falls
New York	South Hempstead
New York	South Hill
New York	South Huntington
New York	South Lockport
New York	South Nyack
		South Orange	New Jersey
		South Plainfield	New Jersey
		South River	New Jersey
		South Toms River	New Jersey
New York	South Valley Stream
New York	Southampton
New York	Southampton
New York	Southold
New York	Southport
New York	Spackenkill
New York	Speculator
New York	Spencer
New York	Spencerport
		Spotswood	New Jersey
		Spring Lake	New Jersey
		Spring Lake Heights	New Jersey
New York	Spring Valley
		Springfield	New Jersey
New York	Springs
New York	Springville
New York	St. Bonaventure
New York	St. James
New York	St. Johnsville
New York	Stamford
		Stanhope	New Jersey
New York	Stannards
New York	Star Lake
New York	Stewart Manor
New York	Stillwater
		Stockton	New Jersey
		Stone Harbor	New Jersey
New York	Stony Brook
New York	Stony Point
New York	Stottville
		Stratford	New Jersey
		Strathmore	New Jersey
		Succasunna-Kenvil	New Jersey
New York	Suffern
		Summit	New Jersey
		Surf City	New Jersey
		Sussex	New Jersey
		Swedesboro	New Jersey
New York	Sylvan Beach
New York	Syosset
New York	Syracuse
New York	Tannersville
New York	Tappan
New York	Tarrytown
		Tavistock	New Jersey
		Teaneck	New Jersey
		Tenafly	New Jersey
New York	Terryville
		Teterboro	New Jersey
New York	Theresa
New York	Thiells
New York	Thomaston
New York	Thornwood
New York	Ticonderoga
New York	Tillson
		Tinton Falls	New Jersey
New York	Tivoli
		Toms River	New Jersey
New York	Tonawanda
New York	Tonawanda
		Totowa	New Jersey
New York	Town Line
		Trenton	New Jersey
New York	Tribes Hill
New York	Troy
New York	Trumansburg
New York	Tuckahoe
		Tuckerton	New Jersey
New York	Tully
New York	Tupper Lake
New York	Turin
		Turnersville	New Jersey
New York	Tuxedo Park
		Twin Rivers	New Jersey
New York	Unadilla
		Union	New Jersey
		Union Beach	New Jersey
		Union City	New Jersey
New York	Union Springs
New York	Uniondale
New York	Unionville
New York	University Gardens
New York	Upper Brookville
New York	Upper Nyack
		Upper Saddle River	New Jersey
New York	Utica
New York	Vails Gate
New York	Valatie
New York	Valley Cottage
New York	Valley Falls
New York	Valley Stream
New York	Van Etten
		Ventnor City	New Jersey
New York	Vernon
		Vernon Valley	New Jersey
		Verona	New Jersey
New York	Victor
New York	Victory
		Victory Gardens	New Jersey
		Victory Lakes	New Jersey
New York	Village Green
New York	Village of the Branch
		Villas	New Jersey
		Vineland	New Jersey
New York	Viola
New York	Voorheesville
New York	Waddington
New York	Wading River
New York	Walden
		Waldwick	New Jersey
		Wallington	New Jersey
New York	Wallkill
New York	Walton
New York	Wampsville
		Wanamassa	New Jersey
		Wanaque	New Jersey
New York	Wantagh
New York	Wappingers Falls
		Waretown	New Jersey
New York	Warrensburg
New York	Warsaw
New York	Warwick
		Washington	New Jersey
New York	Washington Heights
		Washington Township	New Jersey
New York	Washingtonville
		Watchung	New Jersey
New York	Waterford
New York	Waterloo
New York	Watermill
New York	Watertown
New York	Waterville
New York	Watervliet
New York	Watkins Glen
New York	Waverly
New York	Wayland
		Wayne	New Jersey
New York	Webster
New York	Weedsport
		Weehawken	New Jersey
New York	Wellsburg
New York	Wellsville
		Wenonah	New Jersey
New York	Wesley Hills
New York	West Babylon
New York	West Bay Shore
		West Belmar	New Jersey
		West Caldwell	New Jersey
		West Cape May	New Jersey
New York	West Carthage
New York	West Elmira
New York	West End
		West Freehold	New Jersey
New York	West Glens Falls
New York	West Haverstraw
New York	West Hempstead
New York	West Hills
New York	West Hurley
New York	West Islip
		West Long Branch	New Jersey
		West Milford	New Jersey
		West New York	New Jersey
New York	West Nyack
		West Orange	New Jersey
		West Paterson	New Jersey
New York	West Point
New York	West Sand Lake
New York	West Sayville
New York	West Seneca
		West Wildwood	New Jersey
New York	West Winfield
New York	Westbury
New York	Westfield	Westfield	New Jersey
New York	Westhampton
New York	Westhampton Beach
New York	Westmere
New York	Weston Mills
New York	Westport
New York	Westvale
		Westville	New Jersey
		Westwood	New Jersey
		Wharton	New Jersey
New York	Wheatley Heights
		White Horse	New Jersey
		White House Station	New Jersey
		White Meadow Lake	New Jersey
New York	White Plains
New York	Whitehall
New York	Whitesboro
		Whitesboro-Burleigh	New Jersey
New York	Whitney Point
		Wildwood	New Jersey
		Wildwood Crest	New Jersey
		Williamstown	New Jersey
New York	Williamsville
		Willingboro	New Jersey
New York	Williston Park
New York	Wilson
New York	Windsor
New York	Wolcott
		Wood-Ridge	New Jersey
		Woodbine	New Jersey
		Woodbridge	New Jersey
New York	Woodbury	Woodbury	New Jersey
		Woodbury Heights	New Jersey
		Woodcliff Lake	New Jersey
		Woodlynne	New Jersey
New York	Woodmere
New York	Woodridge
New York	Woodsburgh
New York	Woodstock
		Woodstown	New Jersey
		Wrightstown	New Jersey
New York	Wurtsboro
New York	Wyandanch
New York	Wyantskill
		Wyckoff	New Jersey
New York	Wyoming
New York	Yaphank
		Yardville-Groveville	New Jersey
New York	Yonkers
		Yorketown	New Jersey
New York	Yorkshire
New York	Yorktown Heights
New York	Yorkville
New York	Youngstown
New York	Zena

Also check out: CFM Zen Garden, and jQuery Zen Garden.

Database: Phillip Senn
Design: Ryan Carroll