Results 1 to 2 of 2

Thread: Help to Join

  1. #1
    Join Date
    Mar 2012
    Posts
    4

    Help to Join

    Hello there,

    I am relatively new at this and was wondering if anyone out there could help me with a problem I can't seem to figure out.

    Ok... I have 5 tables I need to join. I can join 4 of them, but the last one is a join table for a many to many relationship.

    The tables and columns in question are:

    tbl_site
    site_ID

    tbl_lems
    lems_ID
    employee_IDref
    site_IDREF

    tbl_rank
    rank_ID

    tbl_rate (this is the join table)
    rate_site_IDref
    rate_rank_IDref
    rate_ID

    tbl_employee
    employee_rankRef
    employee_ID

    The columns that are colored are related


    Thanks, in advance

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you have colour-coded the columns that are to be joined

    why can't you join that last table?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •