maybe along the lines of:

update ticketsaudit a
set a.house_uniquenum =
(select b.house_uniquenum from tickets b
where a.ticket_uniquenum = b.ticket_uniquenum),
a.mud_uniquenum =
(select b.mud_uniquenum from tickets b
where a.ticket_uniquenum = b.ticket_uniquenum)

----- Original Message -----
From: "Fr. Robert Bower" <robertb@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, July 15, 2005 12:06 PM
Subject: [firebird-support] update query


>I am trying to write an update query and I am having problems with
> the firebird syntax.
>
> The query involves 2 tables that are identical in structure but one
> has updated data from another database
>
>
> I want to match up the keys then update the data from the one table
> to the second table
>
> An example that works in a Access but not in firebird is as follows
>
> UPDATE Contacts INNER JOIN Contacts1 ON Contacts.ContactID =
> Contacts1.ContactID SET Contacts.FirstName = Contacts1.FirstName,
> Contacts.LastName = Contacts1.LastName;
>
>
> What would be the proper syntax for Firebird.
>
> Thanks,
>
> Fr. Robert
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>