I need to update the primary key field in two tables sharing this field, I can't update separately because I get an integrity violation message that tells me the field is still being referenced from the other table, fair enough but is there any way of doing a joined/linked/double update to the primary key of both tables simultaneously? Something like: UPDATE table1.fieldx, table2.fieldx SET fieldx='yyyyy' WHERE fieldx='zzzzz';
Jake
Jake Matchett
The University of Nottingham
Media Centre
Medical School, Queen's Medical Centre
Nottingham NG7 2UH
(74) 44001
voice +44 (0) 115 9249924 ext 44001
fax +44 (0) 115 9709917
< http://www.nottingham.ac.uk/aves/ >