Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Flag for a value in a list
10 entries of Rep,month,pub
Sele Rep,iif(pub="SA",.T.,.F.) as SA_flag Group by Rep
I want to flag those reps who worked on the SA pub, while also selecting the list of reps. Will this statement work? (in testing, it appears to work) My concern is that if another pub value occurs in the selection after the "SA" value, that the SA_flag value will return to the .F. state.
The alternative is to do 2 separate selections for each group, but i don't want to have to do that...
Any suggestions?
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