TSQL - IF EXISTS SELECT From Mulitple Tables

Dear Gurus,

How do I determine if data exists from multiple tables in SQL Server
2000?

For example,

IF EXISTS
(
( SELECT ColA FROM TableA WHERE ... ) AND
( SELECT ColB FROM TableB WHERE ... )
)
BEGIN
-- Need to do something here
END


Thanks in advance...

Jonathan

re: TSQL - IF EXISTS SELECT From Mulitple Tables

"Jonathan Woods" <yewinzaw@gmail.comwrote in message
news:f5bef686-5504-4fa2-8516-3e8a1b4d4228@25g2000prz.googlegroups.com...Rewrite it as
IF Exists (select...from TableA...) AND Exists (select...from
TableB...)

Another option would be
IF Exists (select... from TableA INNER JOIN TableB ON...)

You may get some better answers if you ask this question in a Sql Server
newsgroup instead of the C# one.