Home Forums SQL Server 2005 SQL Server Newbies How to query same table with 2 WHERE clause onto 1 row RE: How to query same table with 2 WHERE clause onto 1 row

  • September 27, 2013 at 1:18 am

    #1653883

    brett.y (9/27/2013)

    in fact the ONLY one I understand

    It's one of four very similar solutions that have been posted. The only ways they differ are as follows:

    (1) Some use common table expressions (CTEs); some use subqueries

    (2) Some use a comma to join the two tables; some use the CROSS JOIN operator

    John