Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Excluding Parents without children
I have two listboxes with RowSourceType set to SQL. The first listbox shows available parents while the second shows the children of the selected parent that are associated with the local station. I want to modify the SQL statement of the first box so it does not show items that don't have children. Here are the SQL statements:
First ListBox:
SELECT taskID,task ;
FROM tasks ;
ORDER BY task ;
WHERE (active = .T.) ;
INTO CURSOR curTasks
Second ListBox:
SELECT subID, subTask, taskID ;
FROM subTasks ;
ORDER BY subTask ;
WHERE ( taskID = curTasks.taskID .AND. ;
active = .T. .AND. ;
labName = Thisform.labName ) ;
INTO CURSOR curSubTasks
This works except that the first listbox will show items that don't have any children. How do I exclude these? Thanks.
Mon
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