Im having a problem with my code using where code on the inner join
Data5.recordsou rce = "select S.Cpartycode, S.rate, S.valdate, S.Matdate, S.Tenor, D.ID, D.Counterparty from S where rate > 3000 Inner Join D on S.Cpartycode = D.ID;"
it has an error putting where clause
But when I use the code and remove the where clause the code working
Data5.recordsou rce = "select S.Cpartycode,...
ephraem
Last Activity: Feb 21 '11, 05:16 PM
Joined: Feb 19 '11
Location:
-
Problem in using Where Clause in the Join
Last edited by Niheel; Feb 21 '11, 04:04 AM. -
Total Sum of Column 2 in the Table
Hi I would like to compute the total sum of the Table below using DBgrid and not flexgrid using Visual Basic
TABLE1
Column1 Column2
AAA 20
BBB 30
CCC 55
DDD 66
Thanks... -
Summation of per Column in DBGrid
Hi Again,
I would like to know how to compute the sum of per Column on the DBGrid and place it on the textbox
DATABASE1
Table1
Column1 Column2
111 222
333 444
555 666
No activity results to display