is there a way to join the products without using "on"

Now i get

Your SQL is invalid: The multi-part identifier "Orderdetails.ProductName" could not be bound.

So take out the first order by and add it at the end before date?

You can use the GROUP BY for thous

Select *

From TableName

Group By FirstName,LastName

Or how ever you have the name of the columns =)

what rows are you trying to combine and as far as the sum it is

SELECT ItemName, SUM (Item2) AS "OutPut Name"

From...

THANK YOU CALVO!!!!!!!!!!

When i use the second join one it said orderdetails is not a valid column name =(

Instead of selecting all is there away just to bring back certain columns instead of them all because this is a lot.

P.S thank you all for you help so far...

Table 1

OrderDetails

orderdetailidorderidproductcodeproductname ...