D
Dan Wasser
I'm using Excel's database query to get a list of accounts
(ACCTNAME) based on certain criteria (Like INN% and Like
MSS%). But, because INN and MSS occur multiple times
within the same account, Excel is returning those account
names multiple times. But I need (want) the account name
only once. Is there a "distinct" statement or some other
rule/criteria that I can build into the database query to
prevent the account name from appearing multiple times?
Here's the SQL statement from within MS Query (within
Excel):
SELECT ARACCT.ACCTNAME, ARACCT.SALES, ARACCT.ACCTSTAT,
ARACCT.CITY, ARACCT.STATE, ARACCT.OFFTELE,
ARACCT.IHPAYSTAT, ARACCT.IHPAYCMNT, ARTRAN.TRANCODE
FROM ihacct.dbo.ARACCT ARACCT, ihacct.dbo.ARTRAN ARTRAN
WHERE ARACCT.ARCODE = ARTRAN.ARCODE AND ((ARTRAN.TRANCODE
Like 'INN%') OR (ARTRAN.TRANCODE Like 'MSS%'))
ORDER BY ARACCT.ACCTNAME
(ACCTNAME) based on certain criteria (Like INN% and Like
MSS%). But, because INN and MSS occur multiple times
within the same account, Excel is returning those account
names multiple times. But I need (want) the account name
only once. Is there a "distinct" statement or some other
rule/criteria that I can build into the database query to
prevent the account name from appearing multiple times?
Here's the SQL statement from within MS Query (within
Excel):
SELECT ARACCT.ACCTNAME, ARACCT.SALES, ARACCT.ACCTSTAT,
ARACCT.CITY, ARACCT.STATE, ARACCT.OFFTELE,
ARACCT.IHPAYSTAT, ARACCT.IHPAYCMNT, ARTRAN.TRANCODE
FROM ihacct.dbo.ARACCT ARACCT, ihacct.dbo.ARTRAN ARTRAN
WHERE ARACCT.ARCODE = ARTRAN.ARCODE AND ((ARTRAN.TRANCODE
Like 'INN%') OR (ARTRAN.TRANCODE Like 'MSS%'))
ORDER BY ARACCT.ACCTNAME