We are trying to set up a SmartList Builder (and roll down to smartlist) a file to send to our CPA's for the 1099's. I was doing fine until I have a view that has no common fields with the 2nd view. How do I join the following into 1 view? NOTE: the address in the 1st view is the company address and the address in the 2nd view is the vendor's address.
select LOCATNNM, ADRCNTCT, ADDRESS1, ADDRESS2, CITY, STATE, ZIPCODE, ADRSCODE
where LOCATNID = 'main'
select VENDORID, VENDNAME, TXIDNMBR, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, ZIPCODE, TEN99BOXNUMBER
where VENDORID like 'v%'and VNDCLSID like '1099%'and TEN99BOXNUMBER = '7'