| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 21 August 2002 : 11:25:00
|
quote:
Originally posted by Dan Martin
quote:
Originally posted by bax
Really? Access can update multiple tables when you do something like this
update SomeQuery set goo = 1, goo2 = 2
where someQuery is a join between two tables? It would be really fascinating to me if Access can do this, but SQL Server can't (and ironic).
Yes, the entire forums at www.councilofgrey.com run this way, and updates work fine. The only thing it can't do is delete from the joined query.
It should even be possible to delete from the query, I think. I'm sure I have done this in the past. Probably the query just needs some more fields...
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 21 August 2002 : 23:57:55
|
| If I try to delete from FORUM_MEMBERS, I get an error something like "Cannot delete from a derived table" or something along those lines. Its been so long since I tried it though, don't quote me on that. It was a very specific error specifically referring to the join, of that I am sure. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 August 2002 : 00:12:50
|
Dan,
It's possible to delete from queries using joins with Access. There some rules that need to be followed, but it is possible. This means that it is also possible, if you not follow those rules, that you simply cannot do it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
