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