SELECT count(*) IN SELECT

Question

How can SELECT count(*) IN SELECT

I have select:

SELECT t1.idTab1 
FROM table1 t1, (SELECT count(*) FROM table2 t2 WHERE t2.idTab1 = t1.idTab1) 
WHERE t1.idTab1 <= 3

My sample data is:

Table1:

idTab1
1
2
3

Table2:

Tab2CountIdTab1
10
200
30

And in result I want to have:

idTab1 Tab2CountIdTab1 
1      10
2      200
3      30

Is there an id in the second table?

Gordon Linoff
– Gordon Linoff

2014-11-17 14:52:05 +00:00
Commented Nov 17, 2014 at 14:52 — Gordon Linoff
– Gordon Linoff, Commented Nov 17, 2014 at 14:52

user4261009 · Accepted Answer · 2014-11-17 14:29:39Z

3

You may want to use a subquery like this:

SELECT t1.idTab1,
       (SELECT count(*) 
          FROM table2 t2 
         WHERE t2.idTab1 = t1.idTab1) as Tab2CountIdTab1
  FROM table1 t1
 WHERE t1.idTab1 <= 3;

answered Nov 17, 2014 at 14:29

user4261009

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

Collectives™ on Stack Overflow

SELECT count(*) IN SELECT

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