>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.