I have 4 SQL tables that all i am using same primary key i need below condition SQL Quey : I have 4 [ client,clientmanager,Employee,project] tables in sql that all tables i am using primarykey for same (clientid) so i like to count list of projects,Employee,clients mangers using 'clientid " 