Home Forums SQL Server 2005 Development subqurey omits too records from table trvchar ---can any one help to join RE: subqurey omits too records from table trvchar ---can any one help to join

  • Quick thoughts, change the old style ANSI joins to normal joins, move any join conditions from the where clause to the joins and then check for any remaining LEFT table conditions which might force an inner join in the execution plan.

    😎

    This query is rather unclear and obfuscated, suggest you format it, use the proper code tags when posting and provide a runnable example schema and sample data.