SQL Statement Appears correct, but doesn't work.

[markphsd]

What is wrong with this:

UPDATE tblOrders
INNER JOIN tblOrderPayment ON tblOrders.OrderID = tblOrderPayment.OrderID
SET tblOrderPayment.OrderDate = tblOrders.ScheduleDate

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[gmmastros]

Couple things. Take a look at this...

UPDATE tblOrderPayment
SET    tblOrderPayment.OrderDate = tblOrders.ScheduleDate 
From   tblOrders
       INNER JOIN tblOrderPayment 
          ON tblOrders.OrderID = tblOrderPayment.OrderID

-George

"the screen with the little boxes in the window." - Moron

 

[markphsd]

Thanks

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.