Hi Grant, Looks like you want to use IN instead of =
# DELETE from metabib.metarecord_source_map where source IN (SELECT id FROM biblio.record_entry where tcn_value like 'cis%'); ~James Fournie BC SITKA Team On Wed, Oct 22, 2008 at 1:54 PM, Grant Johnson <[EMAIL PROTECTED]> wrote: > I don't want to change the table constraints in Evergreen. > But have a training opportunity for someone. :-) > > We need to delete some electronic records without items from the catalog.(for > now). > These records have a biblio.record_entry.tcn_source of LIKE 'cis'. > > I can't delete from biblio.record_entry as it's referenced as a foreign_key > in .metarecord. > I can't delete from .metarecord as it's referenced as a foreign key in > .metarecord_source_map. > I CAN remove the rows one at a time from the msm -> m -> re and the record is > gone. > > Can someone help with the syntax on how to batch delete the following..... > and let me know if this is all wrong! > > I know what this means - and am looking up how to build the syntax tonight: > - ERROR: more than one row returned by a subquery used as an expression... > :-) > > # DELETE from metabib.metarecord_source_map where source = (SELECT id FROM > biblio.record_entry where tcn_value like 'cis%'); > # DELETE from metabib.metarecord where master_record = ((SELECT id FROM > biblio.record_entry where tcn_value like 'cis%'); > # DELETE from biblio.record_entry where tcn_value like 'cis%'); > > > Table References: > biblio.record_entry > id = 14497 > > metabib.metarecord > id=17448 master_record=14497 > > metaib.metarecord_source_map > id=14710 metarecord=17448 source=14497 > -- > > F. Grant Johnson > Systems Coordinator > Robertson Library > University of Prince Edward Island > >
