Sqlstatement
May 4, 2007In first .aspx page in a gridview iam taking the Names from Produts and count from Productlist.
Names products
aaaa 2
bbbb 2
cccc 1
In the second page in a gridview. when i click on the aaaa i want the values of produts and the count of prodution from productionmaker.
productlist looks as
Names products
aaaa uuuy
bbbb jkkkkkj
aaaa lyuuu
bbbb uyuyu
my productionmaker looks as
Names produts production makerk
aaaa jkkkkkj uuuuuu jtyty
bbbb uyuyu yyyyyy iiiiiiii
aaaa jkkkkkj ytuuuyyy rerer
bbbb uyuyu xxxxxx iuooi
when iam using this sql statement
"SELECT [Productlist].[products], Count([productmaker].[production]) AS [Totalproduction] FROM [productlist] LEFT JOIN [productmaker] ON [productmaker].[production] = [productlist].[products] GROUP BY [productlist].[product]
iam getting the output as
products totalprodution
jkkkkkj 0
uyuyu 0
i want the output in second.aspx page.
products totalproduction
jkkkkj 2
uyuyu 2