Help to join - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Help to join

Author

Topic

clawr687
Starting Member

2 Posts

Posted - 2012-03-06 : 00:49:34

Hello all.

I am relatively new to this and was wondering if anyone could please offer some insight to my problem.

I am trying to join 5 tables together, 1 of which is a joiner table in a many to many relationship.

The tables and columns in question are:

tbl_site
site_ID

tbl_rank
rank_ID

tbl_rate (this is the joiner table for the above 2 tables)
rate_ID
rate_site_IDref
rate_rank_IDref

tbl_Lems
Lems_ID
employee_IDREF
Site_IDREF

tbl_employee
employee_rankRef
employee_ID

Thanks in advance

gtabetnj
Starting Member

8 Posts

Posted - 2012-03-06 : 07:36:24

OK - I see the basic tables, but what exsctly is the problem?

gej

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources