RE: SQL Gurus Wanted

-----Original Message-----
From: Joe Pluta

From: Porterfield, Sean

UPDATE File1
SET File1.Data1 = File2.Data1
FROM File1, File2
WHERE File1.Key1 = File2.Key1

Should this work correctly? Thanks.

Sean, as far as I know the syntax above won't work at all.

However, without the WHERE EXISTS, the query will update all
records in A.

Thanks, Joe. I created some simple tables to test this out; it helps a lot to see it in action.

My version produced "Column qualifier or table FILE2 undefined." Using yours without the WHERE EXISTS, every record was updated. With the WHERE EXISTS, I got exactly what I expected.

I guess this is just a syntax difference between MS SQL Server and System i SQL. Luckily it seems with the subselect and where exists, I can use it on either platform.
--
Sean Porterfield

This email is confidential, intended only for the named recipient(s) above and may contain information that is privileged. If you have received this message in error or are not the named recipient(s), please notify the sender immediately and delete this email message from your computer as any and all unauthorized distribution or use of this message is strictly prohibited. Thank you.