Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Writing a SQL statement.
I am not sure how to write a SQL statement were I have 3 tables, and I want to do a count on 1 field in each table and store it in a cursor. I use a variable as a filter. I know how to write the code for 1 table, but am having troubles writing it for 3 tables. The 3 tables are not linked together in any way.
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement