have a report with ex: Invoice table (invoice_no, cust_no),
Address_table (cust_no)
Need to print invoices along with the customer address.
I put a link on Invoice table (cust_no) ---> Address table
(cust_no)
All I get is 1 row printing.
I take the link off and I get all the data.
I change the link to a lef outer join and it still does not work.
When I change the link: Address table (cust_no) ---> Invoice table
(cust_no)
get the data all invoices
I thought by putting a left outer join on the invoice tabke to the
address table I should get all the records in the invoice table and all
values in the address table that match the invoice table.
Now I am totally confussed
Address_table (cust_no)
Need to print invoices along with the customer address.
I put a link on Invoice table (cust_no) ---> Address table
(cust_no)
All I get is 1 row printing.
I take the link off and I get all the data.
I change the link to a lef outer join and it still does not work.
When I change the link: Address table (cust_no) ---> Invoice table
(cust_no)
get the data all invoices
I thought by putting a left outer join on the invoice tabke to the
address table I should get all the records in the invoice table and all
values in the address table that match the invoice table.
Now I am totally confussed