Operator '<=' facing multi-value data

I have the following code:

select * from Request_History
where
      Stage_No <= (select Stage_No from Work_Flow where Role_ID='7')

The question is: this (select Stage_No from Work_Flow where Role_ID='7') sometimes return more than one value, then what operator other than the '<=' shall I use in this case?
alfardanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Terry WoodsConnect With a Mentor IT GuruCommented:
Or one of these, depending on the result you want when there's more than one row returned by the subquery:
select * from Request_History
where Stage_No <= (select min(Stage_No) from Work_Flow where Role_ID='7')
 
select * from Request_History
where Stage_No <= (select max(Stage_No) from Work_Flow where Role_ID='7')

Open in new window

0
 
Jim P.Commented:
Try this:
select * 
from Request_History
where Stage_No IN (select Stage_No 
                   from Work_Flow 
                   where Role_ID='7')

Open in new window

0
 
lwadwellConnect With a Mentor Commented:
Hi alfardan,

perhaps you should do

lwadwell
select * from Request_History
where
      Stage_No <= (select max(Stage_No) from Work_Flow where Role_ID='7')

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.