--- Christopher E <[EMAIL PROTECTED]> wrote: > Could I just write one query that does > > selects the first record in irs_rawdata only field (EIN) > > select all fields of the record with the ein and check if it matches > in the block table if not then checks match WHERE clause insert into > query if matched and if not match insert only ein into block > > there must be a way, this would make the script much much faster I believe! > > Thank you very much for you help ahead of time! > > Sincerely, > Christopher
You probably want a REPLACE INTO query with the ein as the primary key and a WHERE clause that checks a joined table. However, not knowing anything about your table fields, I can't be more specific. If this was in a previous post, I don't recall the details. James
