VName (No column name) 1 1 1 abc 1 abc 1 dfg 1 dfg 1 dfg 1 dfg 1 dfg 1 dfg 1 abc 1 abc 1 abc 1 dfg 1 abc 1 abc 1 DPSCB 1 MV 1 MV 1 MV 1 MV 1 MV 1 MV 1 MV 1
abc 7 dfg 7 DPSCB 1 MV 7 3 (this is empty but i have to count this also )
tblvv ID MID VName Speed Name 1 2 abc 2 3 abc 3 51 abc 4 67 5 56 dfg 6 45 dfg 7 34 MV 8 24 MV <pre> AND so on tblrv <pre lang="SQL"> ID FFID OName regno City 1 106 Peter AJ-29 uk 2 105 Max AVL-91 US 3 104 John AVL-995 US 4 148 M Jon P AVL-97 uk 5 109 sAR AM-713 US 6 102 dAVID ASJ-9 uk <pre>
ID
Select VName,COUNT(VName) from tblVV join tblRV on tblVV.MID = tblRV.ID group by VName ORDER BY ISNULL(VName, 'zzzz')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)