>>>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>>>