General information
Category:
Coding, syntax & commands
> SELECT COUNT(table1.field1) as t1;
> FROM dbtables!table1 WHERE table1.field1=somevarible into cursor; finalresults
>
>The variable condition is the same for all 3 tables. If someone can help me, I would appreciate it.
>
>TIA,
>Jim
select file1
count thisfield for thiscondition to variable1
select file2
count thisfield for thiscondition to variable2
select file3
count thisfield for thiscondition to variable3
GrandTotal = variable1 + variable2 + variable3
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only