The Fei's Tech Notes
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment