Sorry, I'm assuming alot. I'm new at this thread thing.

Table 1 contains all ProspectIDs in the table, i have separated them into even and odd based on the ID,...

ID          ProspectID    Notes          ProspectID  ID         

482068      126140      not in til       126140      482067

482094      126163      vm left msg   126163      482093

482282      126305      n/a              126305      482281

482298      126320      n/a              126320      482297

482302      126323      vm no msg 

Here are...

Great, That worked

Where ...

 and (ID % 2) = 0

THANKS!