=> Update Query

#1

It's hard to say without details of the tables and
datatypes.

Are the columns that are being compared of the same
datatype?
Is 'A*' meant to be a wild character condition?
If so theh this should be:
WHERE [Deliveries Made].RDC LIKE 'A%'
Is the Dateformat set to dd/mm/yyyy ?

HTH,
Eric

Quote:

-----Original Message-----
Hello,

Is there anything obviously wrong with this UPDATE
query. I receive the errmsg: Syntax Error (missing
operator). Not sure, any ideas?

UPDATE AsdaOrders
SET AsdaOrders.Run = [Deliveries Made].Wave
FROM AsdaOrders INNER JOIN [Deliveries Made] ON
(AsdaOrders.RDC = [Deliveries Made].RDC) AND
(AsdaOrders.DelDate = [Deliveries Made].[Del Date])
WHERE [Deliveries Made].RDC = 'A*'
AND [Deliveries Made].[Del Date] BETWEEN '11/07/2003'
AND '12/07/2003'
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

=> Update Query

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq

=> Update Query - 07-31-2003 , 08:42 AM