Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Need to do a selective join

Posted on 2010-08-27
2
Medium Priority
?
384 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Accepted Solution

by:
pivar earned 2000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

609 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