I keep getting an error..Keeps say invalid use of ,;() in query expression

[emmebanx]

SELECT   T1 . ItemName   as FirstItem,
         T2 . ItemName  as SecondItem
FROM     Order_Data T1 , Order_Data  T2
WHERE    T1 . OrderNumber  = T2 . OrderNumber
  AND    T1 . ItemName  <>  T2 . ItemName

[patjones]

How come you have spaces around all the "."'s? Definitely get rid of them:

SELECT T1.ItemName AS FirstItem,
       T2.ItemName AS SecondItem
FROM Order_Data T1, Order_Data T2
WHERE T1.OrderNumber = T2.OrderNumber AND T1.ItemName <> T2.ItemName

Pat

[colintis]

Continued with Pat, remember to add the semi-colon (;) at the end

[NeoPa]

You may also want to consider using the ON part of the FROM clause in place of the WHERE clause :

SELECT   T1.ItemName as FirstItem
        ,T2.ItemName as SecondItem
FROM     Order_Data AS T1 INNER JOIN
         Order_Data AS T2
  ON     T1.OrderNumber=T2.OrderNumber
  AND    T1.ItemName<>T2.ItemName