Select Statement CrossCompany using X++

 this example to return the first only vendor name by the vendor account from all companies (CrossCompany) : 

select firstonly crossCompany  _vendtable

                   join  _dirpartytable

                  where _vendtable.Party == _dirpartytable.RecId &&_vendtable.AccountNum==this.AccountNum ;