One row results
Hello all,
This is probably very simple but I cannot get it to work today. I would appreciate someone setting me straight.
I would like to return 1 row where the document date is the greatest date. I have a link that shows the result of the included query. I would like help in figuring out how return 1 row where document_date = 09-Jun-12 and Tracking_number = 333444.
example
select oe.order_number, y.document_date, y.tracking_number
from oe_order_headers_all oe,
(select max(x.document_date) document_date , x.header_id, x.tracking_number
from xxprk_doc_tracking_details x
This is probably very simple but I cannot get it to work today. I would appreciate someone setting me straight.
I would like to return 1 row where the document date is the greatest date. I have a link that shows the result of the included query. I would like help in figuring out how return 1 row where document_date = 09-Jun-12 and Tracking_number = 333444.
example
select oe.order_number, y.document_date, y.tracking_number
from oe_order_headers_all oe,
(select max(x.document_date) document_date , x.header_id, x.tracking_number
from xxprk_doc_tracking_details x
0