SQL Query question
SQL Query question
(OP)
Hi All,
I have a question regarding SQL queries I hope somebody can help me with.
I am trying to create a query in a software called HP quality center in order to extract requirements but need some help.
Under the requirements section we created folders with the name (Name test1 , Type FOLDER)
Under each folder we created set of requirements. Is there an easy way to extract all requirements where folder name = foldername1
---
Select REQ.RQ_USER_03,REQ.RQ_USER_03
FROM
REQ
No how to I say only select the requirements if they are in located in a folder named test1 ?
thanks
I have a question regarding SQL queries I hope somebody can help me with.
I am trying to create a query in a software called HP quality center in order to extract requirements but need some help.
Under the requirements section we created folders with the name (Name test1 , Type FOLDER)
Under each folder we created set of requirements. Is there an easy way to extract all requirements where folder name = foldername1
---
Select REQ.RQ_USER_03,REQ.RQ_USER_03
FROM
REQ
No how to I say only select the requirements if they are in located in a folder named test1 ?
thanks
RE: SQL Query question
Select REQ.RQ_USER_03,REQ.RQ_USER_03
FROM req
WHERE folder = 'test1';
This assumes a column called "folder"; you may need to change this to fit your actual situation (or give us more information about your table structure).
RE: SQL Query question
http://tinypic.com/view.php?pic=2j0z512&s=6
RE: SQL Query question