MSSQL query dilema
Posted on 2011-03-16
I have two tables.
invoice & banking
Under my banking table I have check number, and under invoice table, I have the same check number.
I need it to return all my check details and include the invoice number(s) as well.
So my query returns all the checks I have written just fine, but I need it to also show me which invoice(s) I have it written for.
One check may have paid several invoices.