1. Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!

SQL Help

Discussion in 'BBS Hangout' started by Lil Pun, Jul 18, 2011.

  1. Lil Pun

    Lil Pun Member

    Joined:
    Oct 6, 1999
    Messages:
    34,143
    Likes Received:
    1,038
    I need some more assistance, I'm still not quite sure how to use joins.

    I want to run some code to find certain data in different tables. Here is an example of what I am trying to put together:

    Here are the fields:

    table1_person_ID

    table2_credit_type

    table3_credit

    I want to find any ID whose record is not NULL on table2 and has 2 or more records corresponding to the record on table2 on table3.
    I figure this is possible with joins but I've never joined more than one table.

    Isn't that what I would have to do or am I over thinking it?
     

Share This Page

  • About ClutchFans

    Since 1996, ClutchFans has been loud and proud covering the Houston Rockets, helping set an industry standard for team fan sites. The forums have been a home for Houston sports fans as well as basketball fanatics around the globe.

  • Support ClutchFans!

    If you find that ClutchFans is a valuable resource for you, please consider becoming a Supporting Member. Supporting Members can upload photos and attachments directly to their posts, customize their user title and more. Gold Supporters see zero ads!


    Upgrade Now