Information générale
Catégorie:
Codage, syntaxe et commandes
I have the following SQL statement as the rowsource of a dropdown box that works fine:
SELECT '***All Sales Reps*** ' AS Name, '*****'AS
salesrepid FROM salesreps UNION SELECT ALLTRIM(lastname)+', '+ALLTRIM
(firstname) AS Name,salesrepid FROM salesreps INTO CURSOR curSalesRep ORDER BY name
I would like to add a WHERE statement to the second Select statement as follows:
SELECT '***All Sales Reps*** ' AS Name, '*****'AS salesrepid FROM salesreps UNION SELECT ALLTRIM(lastname)+', '+ALLTRIM(firstname) AS Name,salesrepid FROM salesreps INTO CURSOR curSalesRep WHERE salesreps.active = 1 ORDER BY name
However, when I do this I get a syntax error. What am I doing wrong? What is the correct syntax for this statement?
Thanks in advance,
Russell
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