I don't know... I miss-read the data and if it was how it thought it
was it wouldn't have worked anyhow!!!
John
ZeldorBlat wrote:
> Why would you do all that?
>
> upate tblTrades
> set MemberNo = l.MemberNo
> from tblTrades t, tblLogin l
> where t.RegNo = l.RegNo
> and t.Country = l.Country