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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement