CREATE SQL VIEW lv_lt2000 AS SELECT Persinfo.proprty_id, Persinfo.batch, Persinfo.rpt,; Persinfo.appstatus, Persinfo.ssn, Persinfo.name, Persinfo.app_type,; Persinfo.hec, Persinfo.yoba, Persinfo.part, Persinfo.p1line2,; Persinfo.p2line2, Persinfo.totincome; FROM homested!persinfo; WHERE Persinfo.appstatus = "OK"; AND (Persinfo.yoba BETWEEN 1 AND 1932 OR Persinfo.syob BETWEEN 1 AND 1932); AND ((Persinfo.part = 1 AND Persinfo.p1line2+Persinfo.p1line3 < 2000); OR (Persinfo.part = 2 AND Persinfo.p2line2+Persinfo.p2line3 < 2000)); ORDER BY Persinfo.batch, Persinfo.rpt
SELECT Persinfo.proprty_id, Persinfo.batch, Persinfo.rpt,; Persinfo.appstatus, Persinfo.ssn, Persinfo.name, Persinfo.app_type,; Persinfo.hec, Persinfo.yoba, Persinfo.part, Persinfo.p1line2,; Persinfo.p2line2, Persinfo.totincome; FROM homested!persinfo; WHERE Persinfo.appstatus = "OK"; AND Persinfo.yoba BETWEEN 1 AND 1932; OR (Persinfo.syob BETWEEN 1 AND 1932; <--- notice the "(" AND Persinfo.part = 1; AND Persinfo.p1line2+Persinfo.p1line3 < 2000); <-- notice the ")" OR (Persinfo.part = 2; <-- ditto AND Persinfo.p2line2+Persinfo.p2line3 < 2000); <-- ditto ORDER BY Persinfo.batch, Persinfo.rptThe view designer used standard boolean logic to parse the data in the