Originally posted by trey85stang
i mean use access as a "client" a front end, with the SQL being a backend.
Only way to learn SQL is to write SQL. If you are using Access as a front end, you won't be learning SQL (Structured Query Language).
You need to be learning why this does what it does...
SELECT DISTINCT Profiles.* FROM Profiles
(Select RECORDNO from floorplans
INNER JOIN bathroom_lookup ON floorplans.bathroom_id = bathroom_lookup.bathroom_id
INNER JOIN bedroom_lookup ON floorplans.bedroom_id = bedroom_lookup.bedroom_id
convert(int,floorplans.price1) >= 200
AND convert(int,floorplans.price2) <= 300
ON FLRPLAN.RECORDNO = Profiles.RECORDNO
INNER JOIN Amenities ON Profiles.RECORDNO = Amenities.RECORDNO
WHERE (Profiles.property_visible = 1)
AND ( zip = '75234' or zip = ' 75244' or zip = ' ' )
AND profiles.year_built >= 1800
order by prop_ranking desc