Question: I have Operation Aborted each time I Refresh my website's page.
I read the article of MSFT about this issue, and I dont have that case.

I have a div inside the body that appends a script to the head
and the head modifies all the body elements...

What can cause this??

Thanks !

Answer: 
Perhaps you meant

```
SELECT *
  FROM MY_TABLE
  WHERE (FIRST_NAME, LAST_NAME) NOT IN (SELECT FIRST_NAME, LAST_NAME
                                          FROM SOME_OTHER_TABLE)

```

This is allowed under Oracle - not sure about SQL Server.

Share and enjoy.
It is not clear what you are asking, but I gather that you would like to have a NOT IN condition based on two columns instead of just one.

As an example, lets say you have a column called F\_Name and another called L\_Name (both variable in size), and that you want to exclude specific combination of those names from another table that has them already combined as NAME. In that case, you could do this:

```
select F_name
     , L_name
     , col1
     , coln
  from mytable1
 where F_name                  -- First name (variable length)
    || ' '                     -- appended to a blank space
    || L_name                  -- appended to the last name (v)
       not in                  -- is not one of these names
     ( select name
         from mytable2
        where ...
     )

```

The main issue with this query is that you must get the formatting just right so that they can match up exactly. 

If you are dealing with a combination of fields with different types, like numeric and timestamps, then use any of the conversion commands (DECIMAL, INTEGER, CHAR, SUBSTR ...) at your disposal to convert to text equal and then match it up accordingly.