Comments by moniegold18 (Top 1 by date)

I tried to replicate your query. But it gives me much error. For example, your table1 - insert values does not match your parameters has 6 but your Values are only 5. Next is in your table4

(id INT PRIMARY KEY CLUSTERED, int tbl1_id, cnt INT)

should be

(id INT PRIMARY KEY CLUSTERED, tbl1_id INT, cnt INT)

Can you see the difference?

Last, when I tried to execute your SELECT Statement,
it gives me an error "Invalid column name 'cnt'." I found out that there is no field CNT in Table3.

Please correct all of this first.
Thank you.