MySQL Query Multiple Tables

Question

I'm working on a script that requires gathering information from a few different tables, and I just want to know if there is a way to handle my situation without running multiple queries. I'm a little new to mySQL and this example would really help with future situations.

tbl1 = foo_id, bar_id
tbl2 = foo_id, bool, num_id

From tbl1 I need to grab the foo_id where the bar_id = (random number), and then with that foo_id grab the num_id from tbl2 where the bool = 1.

Thanks in advance!

Have you learned about JOINs yet? I think you should look into INNER JOINS in MySQL — MJB
– MJB, Commented May 13, 2014 at 17:48

Alexandre FILLATRE · Accepted Answer · 2014-05-13 17:51:21Z

1

You can try that :

SELECT t2.num_id
FROM tbl1 t1, tbl2 t2
WHERE t1.bar_id = number
    AND t1.foo_id = t2.foo_id
    AND t2.bool = 1

answered May 13, 2014 at 17:51

Alexandre FILLATRE

1,32911 silver badges21 bronze badges

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

1 Comment

tcornell05 Over a year ago

Perfect, I get it. Thank you!!

ravikumar · Accepted Answer · 2014-05-13 18:11:09Z

1

you try using joins ,

SELECT t2.num_id
FROM tbl1 t1 INNER JOIN tbl2 t2 ON t1.foo_id = t2.foo_id
WHERE t1.bar_id = number
AND t2.bool = 1

answered May 13, 2014 at 18:11

ravikumar

9031 gold badge8 silver badges12 bronze badges

Collectives™ on Stack Overflow

MySQL Query Multiple Tables

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related