?
Solved

double inner join

Posted on 2014-03-20
1
Medium Priority
?
483 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
[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
1 Comment
 
LVL 24

Accepted Solution

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

649 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