Queries with Multiple Constraints

Question

I have the following tables and fields:

+------------------+  +-------------------+  +---------------+
| Request          |  | RequestItem       |  | Item          |
+------------------+  +-------------------+  +---------------+
| + Requester_Name |  | + Request_No      |  | + Item        |
+------------------+  +-------------------+  +---------------+
| + Request_No     |  | + Item            |
+------------------+  +-------------------+

I would like to filter the items which are selected under a particular request number, along with a specific requester name. How might I go about doing this?

Answer 1

In SQL? Of course I haven't tested this, but what about:

SELECT items
FROM item INNER JOIN requestitem ON item.items = requestitem.item
WHERE requestitem.request_no = Whatever_Request_Number_You_Want

Or how about:

SELECT items
FROM item INNER JOIN requestitem ON item.items = requestitem.item
INNER JOIN request ON requestitem.request_no = request.request_no
WHERE request.requester_name = 'Whatever_Name_You_Want'

Answer 2

Making some assumptions about what the data looks like, but here's a try:

SELECT item
FROM requestitem
    JOIN item ON requestitem.item = item.item
    JOIN request ON requestitem.request_no = request.request_no
WHERE
    request.request_no = 8642
    AND request.requester_name = 'Specific J. Requester';