General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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?
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