MYSQL with multiple SUBQUERIES

Question

Hi and thanks for reading.

SELECT DISTINCT (thisID and thisNAME) from table1 WHERE thisID IN
(SELECT id from table2 WHERE ... condtions)
OR 
(SELECT id from table3 WHERE ... different condtions)
OR 
(SELECT id from table99 WHERE ...even more conditions)

I need to perform a few SELECTS to provide a nu,ber of thisID's once I have these I need to select only thethisID and thisNAME from the table 1.

I must admit Im a little out of my depth with writing queries...but Im certain Im on the right lines? Any help please??

you should add your table schema, some sample data and your expected results — pala_
– pala_, Commented May 18, 2015 at 1:19
im simply looking for the correct syntax in building the actual query. The rest I can work out. Which bit of the question would you need ellaborating to help? — Will
– Will, Commented May 18, 2015 at 1:21

Gordon Linoff · Accepted Answer · 2015-05-18 01:21:42Z

3

Your SQL is pretty close. You need to repeat the IN part and fix a few outher syntactic stuff:

SELECT DISTINCT thisID, thisNAME
from table1
WHERE thisID IN (SELECT id from table2 WHERE ... conditions) OR 
      thisID IN (SELECT id from table3 WHERE ... different conditions) OR
      thisID IN (SELECT id from table99 WHERE ...even more conditions);

answered May 18, 2015 at 1:21

Gordon Linoff

1.3m62 gold badges706 silver badges858 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Will Over a year ago

looks very promising... gonna code it up and let you know. Thanks for posting :-)

Collectives™ on Stack Overflow

MYSQL with multiple SUBQUERIES

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related