I have three tables, TableA, TableB, and TableC each has a unique ID
field, idA, idB, idC respectively each table also has a field called
'Status'. The id field is always greater than zero. Now suppose I have
three variables A, B, and C. Two of them are zero and the other is a
valid ID for
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
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,
