Hi.
With MySQL, there is not (yet) a way to do this with a single
command. A poor SQL work-around is possible, but a bit bloated.
On the other hand, ta.f1 is a redundand field (regarding tb.af1) and
therefore you normally would seldom need a command such as the one
below.
One (quite probably
At the moment, according to the doc:
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#
Missing_Sub-selects
MySQL only support the insert select and Replace Select.
I am not sure if that answer your question as I am not a big guru on it
either, but it is a place to
