Skip to content
Advertisement

Tag: inner-join

Combine Two Queries into One?

I have a MySQL query that selects all audioids from a certain user in a subscribe table. I then have another query which takes this list of audioids and matches them against a field called opids in a table called audioposts. It then selects the titles from that audioposts table and joins the users from a users table at the

MySQL – Join part of query to a new query?

I’ve got the following code which queries a table. Then it uses the result to make another query. That result is then used to make a third query. But how do I grab the userid field from the 2nd query in order to grab a name from a users table and join that to the result of the 3rd query?

Advertisement