>set talk on >set escape on >sys(3054,11) >OPEN DATA l:\REDP\DBC\CT\CT >SELECT tranmstr.*,sitemstr.*,; >propmstr.*,bldgmstr.*,; >MiscLndr.LName,Apn,MapNum,BlockNum,LotNum, ; >UnitNum,WardNum,ParcelID ; >FROM TranMstr INNER JOIN SiteMstr on TranMstr.PropID=SiteMstr.PropID ; >INNER JOIN PropMstr on TranMstr.PropID=PropMstr.PropID ; >LEFT JOIN BldgMstr on TranMstr.PropID=BldgMstr.PropID ; >LEFT JOIN MiscLndr on TranMstr.TranID=MiscLndr.TranID ; >LEFT JOIN AssrMstr on TranMstr.PropID=AssrMstr.PropID ; >where Prefcode = "P" AND ZIPCODE='06793' ; >and InactvFl#"A" and COMPLEVL="P" and TranMstr.SellName="Y" ; >INTO TABLE ..\..\work\query\qryU0ZA34J>
>SELECT tranmstr.*,sitemstr.*,; >propmstr.*,bldgmstr.*,; >MiscLndr.LName,Apn,MapNum,BlockNum,LotNum, ; >UnitNum,WardNum,ParcelID ; >FROM TranMstr INNER JOIN SiteMstr on TranMstr.PropID=SiteMstr.PropID ; >INNER JOIN PropMstr on TranMstr.PropID=PropMstr.PropID ; >LEFT JOIN BldgMstr on TranMstr.PropID=BldgMstr.PropID ; >LEFT JOIN MiscLndr on TranMstr.TranID=MiscLndr.TranID ; >LEFT JOIN AssrMstr on TranMstr.PropID=AssrMstr.PropID ; >inner join sometemptable on ZIPCODE=sometemptable.btcCode ; >where Prefcode = "P" ; >and InactvFl#"A" and COMPLEVL="P" and TranMstr.SellName="Y" ; >INTO TABLE ..\..\work\query\qryU0ZA34J>