Quote:
Originally Posted by r937
when a query is used in the FROM clause, as a subquery, it is known as an inline view or derived table, because you can think of the results it produces as thought they were a table
|
ah!! that's the trick to use that I never used in my experience..
Quote:
Originally Posted by r937
now, as a result of the join, you can show the value for t.sales_amount, and you are now sure that it is the correct amount for the latest date
|
prepared the final query and it's working fine..
thanks for your patience on me..
