i need a query to retrieve the following constraint

Posted by ANITHA on Stack Overflow See other posts from Stack Overflow or by ANITHA
Published on 2010-03-24T05:23:41Z Indexed on 2010/03/24 5:33 UTC
Read the original article Hit count: 280

Filed under:

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?

© Stack Overflow or respective owner

Related posts about sql