Example: List all customers who have an order
Using Type I nested query: SELECT Cust_id, Cust_name FROM customer WHERE cust_id IN (SELECT cust_id FROM Order)
Using Inner Join: SELECT Cust_id, Cust_name FROM customer,order WHERE customer.cust_id = order.cust_id
Any information you can provide would be appreciated. Thanks.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Jeremy Kadlec
Get help making an apples-to-apples comparison of database performance in Windows vs. Linux systems. Performance and Tuning expert Jeremy Kadlec ... Continue Reading