RE: Update One of Three tables in a single query

2012-11-29 Thread Rick James
Some combo of IN, EXISTS, UNION? It will probably be verbose. > -Original Message- > From: Andrew Moore [mailto:eroomy...@gmail.com] > Sent: Thursday, November 29, 2012 11:32 AM > To: Chris W > Cc: MYSQL General List > Subject: Re: Update One of Three tables in a single

Re: Update One of Three tables in a single query

2012-11-29 Thread Andrew Moore
What's your use case? I've not heard of a like this done at table/sql level. You could use stored procedures & dynamic SQL to achieve it though. On Thu, Nov 29, 2012 at 5:44 PM, Chris W <4rfv...@cox.net> wrote: > I have three tables, TableA, TableB, and TableC each has a unique ID > field, idA,