I use a subquery to identify What needs to be updated and have the update statement use that set of IDs in its where clause.
Update myTable set ..... where myTable.key in ( Select key from Atable left join btable on ..... where uber code finds what we need chaged ) HTH On Wed, Apr 24, 2013 at 2:08 PM, Gary Jeurink <g.jeur...@charter.net> wrote: > My database training from books leaves me with many questions. I am > building > a billing table so I have a transID (auto incr), studentID (int), classID > (int), clientID (int.. who is billed), cost (float), sessionID (int) and > sessYear (char or int). Now I need a unique compound index of studenID, > classID, sessYear, and sessionID so that a client can only be billed once > for attending that class. Million dollar question, how do I do that? . > something tells me that the transID is unnecessary but experience in fox > pro > tells me that in order to be able to update this record in a view I must > have the transID as->key in order to specify the updatable fields. > > > > Please help. > > > > Gary Jeurink > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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/CAJidMYJR_zG2MSJxzEKK3yTxn4Ryfvqe36QODS=sjmfgxml...@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.
