are these 2 the same?

  • Hey,

    If you remove the filter aka where clause you'll get the full records :). Just the 3 fields from his order tables will show up as null :D.

    As for the other statement it appeares it is not being evaluated. And I belive Flo said also that it doesn't get evaluated as it only applies the condition to the right hand side table.

    PS If no one has a problem with it I am going to blog this so I don't forget about it ;-).

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

  • Hi % 🙂

    ab5sr (3/7/2009)


    The old style outer joins are not allowed, but equi-joins, which are equivalent to INNER JOINs, will probably never be removed; if you did, you'd have to remove EXISTS\NOT EXISTS, and others.

    Every rule is confirmed by its exceptions ;).

    Yihong (3/7/2009)


    how can we get Mikey Mouse & Garfield in with your first query?

    Just replace the LIKE with a NOT LIKE.

    Mohit (3/7/2009)


    PS If no one has a problem with it I am going to blog this so I don't forget about it ;-).

    By my side feel free!

    Greets

    Flo

  • thanks guys.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply