Skip to content
Advertisement

Merge/looping through an sql query with another query?

I don’t think my post title is correct/the best but I don’t really know how to concisely explain it.

I have one SQL query

This returns 600+ results

I then need to run

against every ID returned from the first query.

Is it possible to merge these two queries together to return one table that looks like this

or do I have to run the second query 600+ times and manually copy/paste the data over?

Advertisement

Answer

If I’m not missing something, this is what you need:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement