INSERT INTO Client_Page_Stats(
PageID,
ViewDate)
VALUES (
2,
#CreateODBCDateTime(TodaysDate)#)
SELECT ComplexName, ComplexID, ComplexDesc, ComplexImage,
(SELECT COUNT(*)
FROM RIUnitListings
WHERE RIUnitListings.ComplexID=RIComplexes.ComplexID AND RIUnitListings.Active = 2) AS TotatlApts
FROM RIComplexes
WHERE OrgID = 3
