Home Forums SQL Server 2005 T-SQL (SS2K5) How to join four tables using left outer join RE: How to join four tables using left outer join

  • October 8, 2012 at 5:20 am

    #1546647

    Is this query generated by Crystal Reports?

    You need to know what the relationships are between the tables. If you don't have an ERD (Entity Relationship Diagram), request one from your DBA. It's quite feasible to determine approximately what the relationships might be but it can be painstaking, and it will make assumptions.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden