SELECT Distinct State, City
FROM tblListingMaster
ORDER BY State, City
SELECT DISTINCT txtCity, txtState
FROM tblOpenHouse
WHERE (dtOpen > { fn NOW() })
ORDER BY txtCity
SELECT DISTINCT dtOpen
FROM tblOpenHouse
WHERE (dtOpen > { fn NOW() })
ORDER BY dtOpen
SELECT *, (txtFName + ' ' + txtLName) AS txtRealtor
FROM tblDirectory
WHERE bitFeatured <> 0
ORDER BY txtLName, txtFName
SELECT Distinct Class, Type
FROM tblListingMaster
ORDER BY Class DESC, Type
SELECT ID
FROM tblText
WHERE txtCategory =
AND bitDisplay <>
AND (txtSection =
OR txtSection = )
SELECT *
FROM tblText
WHERE ID =
SELECT *
FROM tblDirectory
WHERE bitFeatured <> American Realty of Dubuque - Real Estate agents to find you a new home!