Help for this page

Select Code to Download


  1. or download this
    SELECT events.b_g FROM events WHERE
     events.b_g NOT IN ((SELECT otf.b_g FROM otf) UNION
                        (SELECT requests.b_g FROM requests))
    
  2. or download this
    # insert all of the values you want to test with IN
    INSERT INTO temp (id, value) VALUES (?, ?);
    
    ...
    # might just rollback instead of deleting if the inserts
    # were never commited.
    DELETE FROM temp where id=?;