Jean, Ok, let's try it this way...if you take out the ta. references in the CAST field does the SQL run or fail?
Bill Anderson On Wed, Oct 29, 2014 at 7:14 AM, Jean MAURICE <jsm.maur...@wanadoo.fr> wrote: > 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. >> >> >> > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/CA+O1enG_d=kmhdhnfs_oh-x1xjpz2fs-169oifc996jvch7...@mail.gmail.com ** 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.
