Updating while joining

From: Saravanan <vsr.saravanan_at_gmail.com>
Date: Mon, 17 Aug 2009 04:02:42 -0700 (PDT)
Message-ID: <79d3bbc8-8eca-406a-b094-375940c3717e_at_w41g2000yqb.googlegroups.com>

I am joining three tables a,b,c of which b and c are really large ( 20 million+ records). The join is running and in the mean time I am updating some rows in the table b and c. Will my join reflect the newly updated data in b and c?
Will the join complete successfully?

Thanks
Saravanan Received on Mon Aug 17 2009 - 06:02:42 CDT

This message: [ Message body ]
Next message: Ed Prochak: "Re: Updating while joining"
Previous message: Álvaro G. Vicario: "Re: ROW_NUMBER() and SQL syntax"
Next in thread: Ed Prochak: "Re: Updating while joining"
Reply: Ed Prochak: "Re: Updating while joining"
Maybe reply: Saravanan: "Re: Updating while joining"
Reply: Tim X: "Re: Updating while joining"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message