Get MAX value when using different tables
Posted by:
Luis Cano
Date: October 31, 2009 08:01AM
Hi,
I have been searching on google for answer to this problem I have but I couldn't find anything.
I have two tables. We can call them TableA and TableB. TableA contains the id and string names of preachers. TableB contains the list of all the sermons preached, with the date and the preacher's id from TableA. I would like to be able to query both tables and get the name of the preacher from TableA with the most recent sermon preached from TableB.
If anyone can help I would really appreciate it. If you need more information don't hesitate to ask.
Edited 1 time(s). Last edit at 10/31/2009 08:01AM by Luis Cano.
Subject
Written By
Posted
Get MAX value when using different tables
October 31, 2009 08:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.