code_scrapping

this might be a basic question, but what tools do you use to debug complex SQL queries? I'm not talking about stored procedures, but such tools are welcome as well; but if you're developing a multi-join lots-of-filters SQL query, and you're not getting the expected number of rows, or filtering is too strict, is there any better approach than manually disecting the query part-by-part?