subtracting queries

I have 2 sql queries, and want to subtract one from the other, if that makes sense, i'm not too sure of the correct terminology.

The results of both queries have a common field, PlayerId.

query1 (select PlayerId, FirstName, LastName from Table1 where ....)

query2 (select PlayerId from Table2 where ....)

Thanks

RamilaYou could do a negation on an IN or Exists query for example:

Select PlayerID, FirstName, etc... FROM Table1 WHERE PlayerID Not IN(Select PlayerID from Table2...)

Sudden Cookie problem is .aspx page

Cookie problem in .aspx application.

I have a cookie problem that makes no sense. I get this error when the page
loads:

Object reference not set to an instance of an object.

I am reading the cookie into a var with standard code.

Where the problem makes no sense is that this application sits on my
network, and all
other machines load the page fine. As has the page loaded on all machines
fine since the application
has been in development. Only now, there seems to be a problem.

The other machines are running XP Pro and Windows 2000 Pro, respectfully.
The machine that throws the error is running XP.

All machines have been updated regularly.

Does any know what in the world could be happening with the XP machine for
it never loads the cookie when the page is requested? (note, no privacy
changes have been made to the browser on the XP machine and the machine is
virus free)

Any help would be greatly appreciated.

Branton EllerbeePost your code please

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b
"branton ellerbee" <blrb@.sbcglobal.net> wrote in message
news:3olOb.6716$kg1.1173@.newssvr24.news.prodigy.co m...
>
> Cookie problem in .aspx application.
> I have a cookie problem that makes no sense. I get this error when the
page
> loads:
> Object reference not set to an instance of an object.
> I am reading the cookie into a var with standard code.
> Where the problem makes no sense is that this application sits on my
> network, and all
> other machines load the page fine. As has the page loaded on all machines
> fine since the application
> has been in development. Only now, there seems to be a problem.
> The other machines are running XP Pro and Windows 2000 Pro, respectfully.
> The machine that throws the error is running XP.
> All machines have been updated regularly.
> Does any know what in the world could be happening with the XP machine for
> it never loads the cookie when the page is requested? (note, no privacy
> changes have been made to the browser on the XP machine and the machine is
> virus free)
> Any help would be greatly appreciated.
> Branton Ellerbee