How to Get information from a column of a column of a table and a column of another table and display in one result?

Asked

Viewed 12 times

0

/In this case I want to take all orders made in 1997 and the value of the 10 best and show however the years is in the Orders table and the value is in the Orders Details table/

select Orderdate From Orders Where Year (Orderdate) = 1997 Order by Orderdate

Select TOP(10) (Quantity*Unitprice) as Total From [Order Details] Order By Total desc

sql-server

  • Is there a field that correlates the rows of each table? If it exists use JOIN.

  • pf edit your question, the title is confused, and put in question tbm the structure of tables

No answers

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.