quote:

---

Originally posted by asentilev

I am not sure about the sql server, i can see with the hosting company.
Sorry, I didn't understand that sqlteam can help for sql queries only when Microsoft SQL Server is used.
Thank you Vinu

---

--Creating Tables

create table Tbl1
(
id int NOT NULL ,
name_id varchar (20) 
) 

ALTER TABLE Tbl1 ADD CONSTRAINT
           id_NCUI UNIQUE NONCLUSTERED
    (
                id
    )


create table TBL2 
(
id int NOT NULL ,
name_id varchar (20) ,
file1 varchar (20) 
)
 
ALTER TABLE TBL2 ADD CONSTRAINT
           id_TBL2_NCUI UNIQUE NONCLUSTERED
    (
                id
    )


create table TBL3 
(
id int NOT NULL ,
name_id varchar (20) ,
file3 varchar (20) 
) 

ALTER TABLE TBL3 ADD CONSTRAINT
           id_TBL3_NCUI UNIQUE NONCLUSTERED
    (
                id
    )


--Inserting Sample Data
    
Insert Into Tbl1
Select 1, 'Name1'
Union ALL
Select 2, 'Name2'

Insert Into TBL2
Select 1, 'Name1',	'File_name1'
Union ALL
Select 2, 'Name1',	'File_name2'
Union ALL
Select 3, 'Name2',	'File_name3'
Union ALL
Select 4, 'Name2',	'File_name4'

Insert Into TBL3
Select 1,	'Name1',	'File_name5'
Union ALL
Select 2,	'Name1',	'File_name6'
Union ALL
Select 3,	'Name1',	'File_name7'
Union ALL
Select 4,	'Name2',	'File_name8'


--Query For Your requirement

Select a.name_id, b.Count_Tbl2, c.Count_Tbl3
	From Tbl1 As a
	JOIN
	(Select name_id, COUNT(name_id) As Count_Tbl2 From TBL2 Group By name_id) As b ON a.name_id = b.name_id
	JOIN
	(Select name_id, COUNT(name_id) As Count_Tbl3 From TBL3 Group By name_id) As c ON a.name_id = c.name_id