I have a query that I'm pretty sure sql can handle although I can't figure out how.
I have two tables: an invoice table and a customer table.
I'd like to select those distict accountnum1, accountnum2 from the invoice table for a given date range and then join the result of that with the customer file (acctnum1, acctnum2) so I can have the full address. I like to be able to have this all in one sql statement. Any help would be appreciated.