Dynamic values to another SQL statement

Question

Is there a way to combine two SQL queries into a single SELECT query in PostgreSQL?

My requirements are as follows:

SELECT id FROM table1;
SELECT name FROM table2 WHERE table2.id = table1.id;

I think I need to pass values of table1.id in as some sort of dynamic values (loop values) for use in the SELECT statement executed on table2. What is the easiest way to solve this problem, is it possible to do this with stored procedures or functions in PostgreSQL?

As @ClodoaldoNeto said, what you're looking for here is a simple INNER JOIN clause, plain and simple. Using functions, triggers or even dynamic SQL in this situation would be exuberant overkill (at best) - please don't do it. — Priidu Neemre
– Priidu Neemre, Commented Sep 14, 2014 at 17:23

Clodoaldo Neto · Accepted Answer · 2013-04-29 13:15:54Z

3

select t1.id, name
from
    table1 t1
    inner join
    table2 t2 using (id)
where t1.id = 1

answered Apr 29, 2013 at 13:15

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

Dynamic values to another SQL statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related