using count using data from 2 tables?

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  March 8, 2007 at 7:02 am

  #176504

  I've got 2 tables and would like to do a Count on 1 table whilst checking against a second table, is this possible?

  table1                                                   table2

  [name]        [age]       [Location]               [name]        [job]         

  fred               20         London                   george         driver

  george           20         London                   tony            plumber

  tony              20         paris                      alice            driver

  jim                21         Milan                      fred             plumber

   

  the sort of query I need is

  count  from table1 where names are also in table2 that are drivers

  any ideas?

• Russel Loski

  SSCertifiable

  Points: 7059

  More actions

  March 8, 2007 at 11:26 am

  #693895

  select count(*) from

  table1 inner join table2

  on table1.name = table2.name

  where table2.job = 'driver'

  Russel Loski, MCSE Business Intelligence, Data Platform

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  March 9, 2007 at 2:43 am

  #694018

  many thanks Russel