On Thursday 12 December 2002 20:35, Mark Goodge wrote: > I'm hoping that someone can give me some pointers on this problem. I have > two tables that contain similar data (eg, people.employees and > people.volunteers). I need to run a select statement to retrieve names from > both tables, and then display the data sorted by name so that it doesn't > matter which table it came from. > > For example, if people.employees contains Amy, Charles and Eric, while > people.volunteers contains Brian, David and Fred, then the resulting output > needs to be displayed in this order: > > Amy > Brian > Charles > David > Eric > Fred > > I could do this by post-processing the data in the script which retrieves > it, but I'd prefer to get it in the correct order direct from MySQL. Any > suggestions?
You can do it with UNION in 4.0.x: http://www.mysql.com/doc/en/UNION.html or with TEMPORARY tables in 3.23.xx -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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