How code 2 left joins in UPDATE sql ???
From: mscertified (rupert_at_tigerlily.com)
Date: 03/25/05
- Next message: Andreas: "Re: How code 2 left joins in UPDATE sql ???"
- Previous message: Andreas: "Re: alias...don't alias at all"
- Next in thread: Andreas: "Re: How code 2 left joins in UPDATE sql ???"
- Reply: Andreas: "Re: How code 2 left joins in UPDATE sql ???"
- Reply: John Spencer (MVP): "Re: How code 2 left joins in UPDATE sql ???"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Mar 2005 15:15:01 -0800
I have tried everything I can think of and get syntax errors. I need to do
UPDATE tblA LEFT JOIN tblB ON tblA.X = tblB.X LEFT JOIN tblC on tblA.Y =
tblC.Y
SET ...,
SET...,
etc. etc.
- Next message: Andreas: "Re: How code 2 left joins in UPDATE sql ???"
- Previous message: Andreas: "Re: alias...don't alias at all"
- Next in thread: Andreas: "Re: How code 2 left joins in UPDATE sql ???"
- Reply: Andreas: "Re: How code 2 left joins in UPDATE sql ???"
- Reply: John Spencer (MVP): "Re: How code 2 left joins in UPDATE sql ???"
- Messages sorted by: [ date ] [ thread ]