I need a query to produce all the records from one table and matching records from another table, if no matching records then assume its a zero.
the report will be a rolling order book so includes the order value from one table, and then will show the corresponding invoice value from the other table, if no invoice has been raised then assume a zero value.
I just can't seem to get my head around it!
TIA