Thursday, January 3, 2013

Oracle: Join Query


select a.joid, b.joid, a.job_name, a.machine, a.owner, b.create_user, b.create_stamp from job a inner join job2 b on a.joid = b.joid where b.create_stamp > '12-12-31' order by b.create_stamp DESC;

No comments:

Post a Comment