Solved

double inner join

Posted on 2014-03-20
1
471 Views
Last Modified: 2014-03-20
Is it possible to select inner join into 2 tables.
I need this information put together:

select * from bkgReciepts
JOIN bkgDivision
ON bkgReciepts.divisionint=bkgDivision.int
where bkgReciepts.int = 199

can I also add,

join bkgLogin
on bkgReciepts.userInt=bkgLogin.id
0
Comment
Question by:rivkamak
1 Comment
 
LVL 24

Accepted Solution

by:
mankowitz earned 500 total points
ID: 39944376
sure.

You can join as many tables as you need.

select * from bkgReciepts
JOIN bkgDivision ON bkgReciepts.divisionint=bkgDivision.int
join bkgLogin on bkgReciepts.userInt=bkgLogin.id
where bkgReciepts.int = 199
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Live Storage Vmotion VMs with shared VMDK 10 64
TSQL query to generate xml 4 36
insert wont work in SQL 14 22
SQL Server Connection String through a VPN 8 31
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

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