Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to connect 2 tables using order by keyword

714072Aug 31 2009 — edited Aug 31 2009
Hi all
I have 2 tables M_PLATE_COST and M_SIZE.

M_PLATE_COST contains SIZE_CODE which is the primary key of M_SIZE

M_SIZE contains a feild called OUTPUT_ORDER and M_PLATE_COST do not contain this feild.

the problem is i need to sort M_PLATE_COST based on OUTPUT_ORDER of M_SIZE.

ex:

Select * from M_PLATE_COST Order By OUTPUT_ORDER of M_SIZE is this possible.

thanks for the help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2009
Added on Aug 31 2009
3 comments
315 views