UPDATE SQL Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 24 Jun 2004 15:25 GMT

hi,
i have 2 tables: tbl-LAWYERMembership and Case Info. What
i would like to do is move a Lawyer's name from tbl-
LAWYERMembership (the field name is FULL), where a
checkbox is checked, to a field in Case Info
called "LAWYER". I have the following SQL statement, but
i keep getting errors.

UPDATE [Case Info] SET [Case Info].LAWYER = [tables] !
[tbl-LAWYERMembership] ! [FULL] WHERE ResponseCheckBox
= 'TRUE';

Can someone please correct me?

thanks in advance,
Rob

Reply to this Message

J Arty - 24 Jun 2004 20:06 GMT

UPDATE [Case Info] SET LAWYER = tbl-LAWYERMembership.FULL WHERE
tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'
from LAWYERMembership

If ResponseCheckBox is defined a bit, then put = 1 instead of TRUE

> hi,
> i have 2 tables: tbl-LAWYERMembership and Case Info. What
[quoted text clipped - 12 lines]
> thanks in advance,
> Rob

Reply to this Message

- 24 Jun 2004 21:23 GMT

hi again,

i got an error saying that an operator was missing. here
is what i have:

UPDATE [Case Info] SET LAWYER = tbl-LAWYERMembership.FULL
WHERE
tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'
from tbl-LAWYERMembership;

can you please correct it again?? thanks a lot!!!

-Rob

Reply to this Message

J Arty - 25 Jun 2004 14:36 GMT

sorry there was a mystake in it hope this takes care of it

UPDATE [Case Info] SET LAWYER = tbl-LAWYERMembership.FULL
from tbl-LAWYERMembership
WHERE tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'

> hi again,
>
[quoted text clipped - 9 lines]
>
> -Rob

Reply to this Message

J Arty - 25 Jun 2004 14:42 GMT

UPDATE [Case Info] SET [Case Info].LAWYER = tbl-LAWYERMembership.FULL
from tbl-LAWYERMembership
WHERE tbl-LAWYERMembership.ResponseCheckBox = 'TRUE'

> sorry there was a mystake in it hope this takes care of it
>
[quoted text clipped - 14 lines]
> >
> > -Rob

Reply to this Message

Rob - 25 Jun 2004 14:52 GMT

i still get an error message which says: "Syntax error
(missing operator) in query expression 'tbl-
LAWYERMembership.FULL from tbl-LAWYERMembership" i'm
sorry to bother you again, but could you look it over one
more time?

thanks,
Rob

>-----Original Message-----
>UPDATE [Case Info] SET [Case Info].LAWYER = tbl-LAWYERMembership.FULL
[quoted text clipped - 21 lines]
>
>.

Reply to this Message