Information générale
Catégorie:
Produits tierce partie
Hi Bill,
PMFJI, but we need some guidance on a 'Too Many Subqueries' issue.
We have a 'task' table that is used two times (alias PickUp, Delivery) The relationship uses an 'and' clause to qualify the relationship. For example, .... FROM Job JOIN Task Pickup ON Job.ptask_ID = Pickup.task_ID AND Pickup.type = 'P' JOIN Task Delivery ON Job.dtask_ID = Delivery.task_ID AND Delivery.type = 'D'.
I think that uses up the two subqueries we are allowed by VFP. If I have need for another (and I do of course) We are greeted with the 'TOO MANY SUBQUERIES' error.
Is there a better approach that will circumvent this issue?
Thanks,
Ken
Précédent
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