Hello, all
I am sure the answer to the following question is well documented in
the manuals, but I just don't seem to recognize it. Please point me to
the relevant documentation.
I have two tables in the database. Some fields are common (Author,
Date) other are specific.
I know how to find the X most recent records in one table, and have
them sorted by any column, but how do I do it on two tables at once?
In other words, how do I find the X most recent records in both
tables, and then sort them by Author name? And how do I know in the
resulting list which table each item came from?
Do I need a common index?
Again, I realize that this is really a FAQ and certainly well
documented issue, I just need to know what its correct "title" is.
Examples are also welcome, of course....
TIA,
mweb
--
There is hopeful symbolism in the fact that flags do not wave in a
vacuum.
-- Arthur C. Clarke
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
