How to use data from a table as a value for another command in SQL?

Question

I have in mind something like this: Let's say there is a

Select Client_name
From Clients_Master_Table
where Client_Name = 'DS_Store';

So, here's how to use 'DS_Store' which is given from the table as a value for the command:

As if to do

Select DS_Store
From DS_Table;

`SELECT * FROM YourTable where CLIENT_NAME IN(SELECT DS_STORE FROM DS_TABLE)` — sagi, Sep 25 '17 at 11:14

score 0 · Answer 1 · answered Sep 25 '17 at 11:14

0

You probably want IN:

Select Client_name
From Clients_Master_Table
where Client_Name IN (Select DS_Store from DS_Table)

answered Sep 25 '17 at 11:14

jarlh

But I want take some value from table and reuse this info as a comand – Dantes Dantonovich Sep 25 '17 at 15:27
Is that possible to do it? – Dantes Dantonovich Sep 25 '17 at 15:27

1 Answers1