How to use the output of select statement to use as a condition in another select

Asked Feb 16 '17 at 08:05

Active Feb 16 '17 at 08:05

Viewed 54 times

How to use the output of select statement to use as a condition in another select. For example:

Select uid from info where id = 1;

Output

|uid|
| 3 |

-- i will use the output of this on the other query which is in dynamic manner.

Select uid from info where id = 3

*the query will stop if there is no any id found. Can you help me to find best practice for it?

asked Feb 16 '17 at 08:05

Amboom

if there is no data means it wont show you any result for the code purpose you need to write the conditions... – Soniya Basireddy Feb 16 '17 at 08:07
Have you actually tried to do this or are we your first port of call? – Option Feb 16 '17 at 08:08
`SELECT uid FROM info WHERE id = (SELECT uid FROM info WHERE id = 1)` – M A SIDDIQUI Feb 16 '17 at 08:09
what if i get another id which is i will use it again on another select statement. It will only stop if there is no row to return. – Amboom Feb 16 '17 at 09:02

0 Answers0