Home Forums SQL Server 2008 T-SQL (SS2K8) How to determine which items in one table do not appear in a second table RE: How to determine which items in one table do not appear in a second table

  • December 20, 2012 at 1:47 am

    #1570446

    Here is another way of doing it:

    Select a.ItemID, b.ActionID From

    (

    Select Distinct ItemID From Items

    ) As a

    CROSS JOIN Actions As b

    Except

    Select ItemID, ActionID From Items

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉