table users id user_id user_name 1 M100001 Shirley 2 M100002 Bruce 3 M100003 Fred 4 M100004 Albert 5 M100005 Elizabeth 6 T100001 Helen 7 T100002 Tracy 8 T100003 Charles 9 T100004 Jack 10 T100005 Ann
table job_records job_id submit_user_id submit_time fixed_user_id fixed_time SC12033214495468 T100003 1203321449 M100001 1203321763 SC12033215980303 T100003 1203321598 M100001 1203321788 SC12033216636547 T100002 1203321663 M100001 1203321796 SC12033216729280 T100004 1203321672 M100003 1203321803 SC12033216819810 T100005 1203321681 M100005 1203321809 SC12033216898223 T100001 1203321689 M100003 1203321816 How to select out data with below format? job_id submit_user_id submit_time fixed_user_id fixed_time SC12033214495468 Charles 1203321449 Shirley 1203321763 SC12033215980303 Charles 1203321598 Shirley 1203321788 SC12033216636547 Tracy 1203321663 Shirley 1203321796 SC12033216729280 Jack 1203321672 Fred 1203321803 SC12033216819810 Ann 1203321681 Elizabeth 1203321809 SC12033216898223 Helen 1203321689 Fred 1203321816 select t1.job_id, t2.user_name, t1.submit_time, t1.fixed_user_id, t1.fixed_time from job_records as t1 left join users as t2 on (t1.submit_user_id = t2.user_id); The output is, job_id user_name submit_time fixed_user_id fixed_time SC12033214495468 Charles 1203321449 M100001 1203321763 SC12033215980303 Charles 1203321598 M100001 1203321788 SC12033216636547 Tracy 1203321663 M100001 1203321796 SC12033216729280 Jack 1203321672 M100003 1203321803 SC12033216819810 Ann 1203321681 M100005 1203321809 SC12033216898223 Helen 1203321689 M100003 1203321816 Thanks in advance!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]