I have 2 tables. the 1st table called ITEM - keep detail about the goods to sales, 2nd called transaction keep sales transaction information for the item.

How can using SQL syntax to list out every item with last transaction date and price?


Thanks.