Date: 03/29/05 (MySQL Communtiy)    Keywords: no keywords

OK, let's say I've got three tables: A, B, and C.

Each of these tables has a field called x, which is typed as DATE.

Now let's say that I want to get the lowest (i.e. MIN) value of x in A, B, and C.

Is it possible to that in a single query?

Source: http://www.livejournal.com/community/mysql/52805.html