On 25/03/2004 2:45 PM -0600 mqueme wrote: > I have this query that takes way too long How can i improve its > performance? 1) What database server are you using? 2) Have you looked at the indexing on the tables in question? How much data is in each? 3) What does the query plan look like? (In MS SQL Server, run SET SHOWPLAN_ALL ON, and then run your query). This will often show where the problem is (look in the EstimateCPU as a good starting place, as well as TotalSubtreeCost) SQL Server Query optimization for dummies, chapter 1: if you see a "Table Scan" in your query plan, and the table involved has a lot of rows, you may well be just one well-thought-out index away from making your query perform well. Cheers, Paul.