Solved

Need to do a selective join

Posted on 2010-08-27
2
378 Views
Last Modified: 2012-06-22
I have created a multi table join and need to join just one more table, please see attachment. I have commented out the table I that is creating the problem. In a nutshell I just want to jjoin each row in the top select with correct row in the bottom table select. But I can't get a unique join, so it's returning two rows becaise band_id and Security_level id have two matches. What I need is to join the top select with the bottom table where band_id and security_level_id (top select) =  band_id and security_level_id (bottom select). I guess this is another level select but just don't know the syntax Screen shot of select and result
0
Comment
Question by:John_Merrick
2 Comments
 
LVL 22

Accepted Solution

by:
pivar earned 500 total points
ID: 33540969
Hi,

Do you mean to do?

join Band_Security_Level f on a.Band_ID = f.Band_ID
AND a.[Security_Level_ID] = f.[Security_Level_ID]

/peter
0
 
LVL 1

Author Comment

by:John_Merrick
ID: 33541000
Thta's precisely what I'm after I didn't realise I could use AND in a join syntax...
 
Thanks very much
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
create an aggregate function 9 36
Inserting oldest record into new table. 5 25
Show Results for Latest DateTime in a View 27 27
T-SQL Default value in Select? 5 29
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question