Subject |
sql code |
From |
Charlie <tm@tc.com> |
Date |
Wed, 13 Jun 2018 14:43:09 -0400 |
Newsgroups |
dbase.getting-started |
Hi... what is wrong here? I am trying to filter this sql statement with where using the variable talname, but I can't seem to get this to work for some reason. I've gotten so many different error messages my head is spinning.
Really appreciate any help!
sql = "select lname,sum(qty) as cnt, sum(qty*cost) as tcost, sum(qty*sell) as tsell from taldata where lname ="+talname+" group by lname"
|
|