posted 19 years ago
Hi,
Is it possible to create a single query that can update 2 tables at once when executed and if it is possible, how is the syntax.
below is the query i use to update the master patient table and i would like the same query to update another table. how do i add on for the other table?
"update master_patient set forename = Substr(forename,1,1),surname=Substr(surname,1,1) where forename is not null "
[ February 10, 2005: Message edited by: Bear Bibeault ]