sql count() query for tables

Question

i have two tables

table1 fields

      fid,fname,fage
      a  ,abc  ,20
      b  ,bcv  ,21
      c  ,cyx  ,19

table2 fields

     rcno,fid,status
     1   ,a  ,ok
     2   ,c  ,ok
     3   ,a  ,ok
     4   ,b  ,ok
     5   ,a  ,ok

i want to display rectors like this

     fid from table1 , count(recno) from table 2 and fage from table1         

     fid,count(recno),fage
     a  ,3           ,20
     b  ,2           ,21
     c  ,1           ,19

i try many sql queries but got error

Thanks

Adriaan Stander · Accepted Answer · 2010-03-27 13:54:31Z

1

You could try

SElECT t1.fid,
       COUNT(t2.fid),
       t1.fage
FROM   Table1 t1 INNER JOIN
       Table2 t2 ON t1.fid = t2.fid
GROUP BY t1.fid, t1.fage

edited Mar 27, 2010 at 13:54

answered Mar 27, 2010 at 13:01

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

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

1 Comment

Adriaan Stander Over a year ago

True, sorry, did it in NotePad++ X-)

Collectives™ on Stack Overflow

sql count() query for tables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related