Use results from one sql query in another where statement

Question

I have these tables in my SQL:

___BookingsDatas

|------------|-----------------|------------|
| BOD_Id     | BOD_BookingId   | BOD_Rate   |
|------------|-----------------|------------|
| 1          | 8               | 19.00      |
| 2          | 9               | 29.00      |
|------------|-----------------|------------|

___Bookings

|------------|-----------------|------------|
| BOO_Id     | BOO_CustomerId  | BOO_RoomId |
|------------|-----------------|------------|
| 8          | 98              | 33         |
| 9          | 99              | 34         |
|------------|-----------------|------------|

___Customers

|------------|-----------------|------------|
| CUS_Id     | CUS_FirstName   | CUS_Name   |
|------------|-----------------|------------|
| 98         | Eric            | Smith      |
| 99         | David           | Black      |
|------------|-----------------|------------|

I want to link these table, so I have this query:

SELECT * FROM ___BookingsDatas INNER JOIN ___Bookings ON ___BookingsDatas.BOD_Id=___Bookings.BOO_Id;

It's working actually.

The problem is on the second table I have some information I need to link with the third one.

For example, I need to have the following results:

|--------|---------------|----------|--------|----------------|------------|--------|---------------|---------|
| BOD_Id | BOD_BookingId | BOD_Rate | BOO_Id | BOO_CustomerId | BOO_RoomId | CUS_Id | CUS_FirstName | CUS_Name|
|--------|---------------|----------|--------|----------------|------------|--------|---------------|---------|
| 1      | 8             | 19.00    | 8      | 98             | 33         | 98     | Eric          | Smith   |
| 2      | 9             | 29.00    | 9      | 99             | 34         | 99     | David         | Black   |
|--------|---------------|----------|--------|----------------|------------|--------|---------------|---------|

So, how can I use results from the first mysql query in another where statement in this case ?

Thanks.

so? you don't know how to add another one inner join to existing one? — Iłya Bursov
– Iłya Bursov, Commented Jan 5, 2017 at 18:14

Newd · Accepted Answer · 2017-01-05 18:54:15Z

1

Maybe I am not understanding the question, but could you just join to the third table?

SELECT * FROM BookingsDatas A 
JOIN Bookings B ON 
   A.BOD_Id=B.BOO_Id
JOIN Customers C ON
   B.BOO_CustomerID = C.CUS_Id
;

edited Jan 5, 2017 at 18:54

Newd

2,1832 gold badges18 silver badges33 bronze badges

answered Jan 5, 2017 at 18:17

SaggingRufus

1,84419 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Use results from one sql query in another where statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related