SELECT * FROM TABLE_1 WHERE <PK> NOT IN (SELECT PK FROM TABLE_2) ----- Original Message ----- From: "Sam Jia" <[EMAIL PROTECTED]> To: "JRun-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 16, 2001 6:35 PM Subject: find different data between 2 tables
> Hi there > > question is: > I have 2 tables in MS SQL server 2000 with same structure. the data of 1st > table may changed by insert, update, and delete query. for each fixed > period, i want all these changes(new difference) of the 1st table during > that period applied to the 2nd table. is there any build in command for this > purpose? or there are other solutions. > > thanks > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
