Home Forums SQL Server 2008 SQL Server Newbies Query - Pulling Data from another table RE: Query - Pulling Data from another table

  • February 21, 2013 at 7:03 am

    #1589941

    Can you give us the results of the below mentioned queries

    SELECT * FROM Bookings WHERE Booking_Skey = 1

    SELECT * FROM PitchValues WHERE PitchType_Skey IN ( SELECT PitchType_Skey FROM Bookings WHERE Booking_Skey = 1 )

    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/