Re: [dba-dev] Updating from Query with Join

2007-08-20 Thread Alex Thurgood
On Monday 20 August 2007 19:14:50 Barbara Duprey wrote: One real problem, though -- I don't seem to be able to update from any query with a join. The keys of both tables are in the data, and I'm only trying to update in the Violations table. As long as I don't have a join, no problem.

Re: [dba-dev] Updating from Query with Join

2007-08-20 Thread Barbara Duprey
Alex Thurgood wrote: On Monday 20 August 2007 19:14:50 Barbara Duprey wrote: One real problem, though -- I don't seem to be able to update from any query with a join. The keys of both tables are in the data, and I'm only trying to update in the Violations table. As long as I don't have a