SQL Language (MOSC)

MOSC Banner

Query on joins

edited Apr 25, 2010 11:48PM in SQL Language (MOSC) 13 commentsAnswered
I have 2 queries that work correctly and give me the correct results. I am trying to find a method to join these 2 queries that will give me the correct results. The aim is to allow me to show the opf.time column in the first query.

Please can someone assist.

Query 1:

select unique obst.name booking_status ,pbg.name country_Opco ,org.name organization

unique obst.name booking_status ,pbg.name country_Opco ,org.name organization

.name booking_status ,pbg.name country_Opco ,org.name organization

,pbg.name country_Opco ,org.name organization ,org.name organization ,oav.version_name course_name

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center