UPDATE QUERY Pervasive 2000i

#1

PROBLEM:
I need to update one table based on a value of another table

QUESTION:
How do you write the query below to update the PERVASIVE DEMO DATA
Billing.Amount_Owed to 100.00 if the
Person.Perm_State = 'GA'

==================================================

UPDATE Billing SET Amount_Owed = 100
---------
I probably need to tell which tables to look at here by how??
---------
WHERE
Billing.Student_ID = Person.ID AND
Person.Perm_State = 'GA'

--
Thanks,
Phil Chapman
Fax (413) 556-5674

#2

Thanks for the help

"Rok Debeljak" <rok.debeljak (AT) email (DOT) si> wrote

Quote:

UPDATE Billing SET Amount_Owed = 100
where student_id in (select person.id from person where
person.Perm_state = 'GA')

Regards,
Rok

Phil Chapman wrote:
PROBLEM:
I need to update one table based on a value of another table

QUESTION:
How do you write the query below to update the PERVASIVE DEMO DATA
Billing.Amount_Owed to 100.00 if the
Person.Perm_State = 'GA'

==================================================

UPDATE Billing SET Amount_Owed = 100
---------
I probably need to tell which tables to look at here by how??
---------
WHERE
Billing.Student_ID = Person.ID AND
Person.Perm_State = 'GA'

--
Thanks,
Phil Chapman
Fax (413) 556-5674

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

UPDATE QUERY Pervasive 2000i

comp.databases.btrieve comp.databases.btrieve

UPDATE QUERY Pervasive 2000i - 07-23-2003 , 01:49 PM

Re: UPDATE QUERY Pervasive 2000i - 07-24-2003 , 02:18 PM