Hi Bill,
this is not an error ! cantine_services and cantine_salles are linked together
(it's a school restaurant, pupils are dispached in 4 groups that eat in 2 rooms)
but tarifs_cantine is independant (it's the cost of different menus) and I want
a 'cartesian product' (?) : on line per tarif and per group.
The global problem is : meals are good and (due to the efficiency of my app ;-)
) not so expensive. The restaurant is sometimes overcrowded and we must stop
registration when the max is reached. I hope you understand.
The Foxil
Le 29/10/2014 14:50, Bill Anderson a écrit :
Jean,
I think issue is a flaw in the JOIN. I don't see how ta ties to the rest of
the join.
FROM cantine_services sv ;
INNER JOIN cantine_salles sal ON sv.salle = sal.clef, ;
tarifs_cantine ta ;
WHERE ta.anscol = lcannee INTO CURSOR
I don't see how tarif_cantine (ta) ties to the other tables unless this is
a shorthand that I'm unaware of.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
