Inner join usage with array

Question

I try to make a filter for my project. And I want to learn how can I use array values in inner join. For example I have a query like this.

SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
INNER JOIN Employees
ON Orders.EmployeeID = Employees.EmployeeID;

But I have multiple EmployeeIDs in array and I try to make my query like this.

SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
INNER JOIN Employees
ON Orders.EmployeeID = Employees.1,2,3;

this is the wrong way I know but I really don't know the right way to make this query.

Join all the employees then limit them in the where clause. ON Orders.EmployeeID = Employees.EmployeeID where Orders.EmployeeID in(1,2,3) — chris85
– chris85, Commented Jun 19, 2017 at 11:44

simhumileco · Accepted Answer · 2017-09-15 11:00:11Z

1

No need to worry about that if there are any number of rows of employee id mapped with the orders it will return that many rows if exist, rather just use a where in clause

SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
INNER JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID 
WHERE Employees.EmployeeID IN (1,2,3);`

edited Sep 15, 2017 at 11:00

simhumileco

35.3k18 gold badges148 silver badges125 bronze badges

answered Jun 19, 2017 at 11:46

Nivedita

1641 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul · Accepted Answer · 2017-06-19 11:44:58Z

0

You can do like this,

SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
INNER JOIN Employees
ON Orders.EmployeeID = Employees.EmployeeID where Employees.EmployeeID IN (1,2,3);

Inner join with employee id will fetch all matching records of both orders and employees with condition of employee id and then on that where clause to fetch those records whose employee id is 1,2,3.

answered Jun 19, 2017 at 11:44

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

Comments

Lajos Arpad · Accepted Answer · 2017-06-19 11:55:06Z

0

You could use the in operator in the on clause:

SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
INNER JOIN Employees
ON Orders.EmployeeID = Employees.EmployeeID and Employees.EmployeeID in (1,2,3);

answered Jun 19, 2017 at 11:55

Lajos Arpad

80.4k42 gold badges123 silver badges234 bronze badges

Collectives™ on Stack Overflow

Inner join usage with array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related