Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to optimize SQL code with IN (....)
Message
From
07/11/2005 10:26:24
Steven Wang
Pil
Shanghai, China
 
 
To
07/11/2005 05:40:21
Virusim Sim
Singapore, Singapore
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: How to optimize SQL code with IN (....)
Miscellaneous
Thread ID:
01065924
Message ID:
01065978
Views:
13
SELECT a.pub_name
FROM publishers a inner join titles b on a.pub_id=b.pub_id and b.type = 'business'
or
SELECT a.pub_name
FROM publishers a
where exists( select 1 from titles b where b.pub_id=a.pub_id and b.type = 'business')
Steven
Previous
Reply
Map
View

Click here to load this message in the networking platform