Help with SELECT statement
Hi,
I have a database with three tables; DOGS, SHOWS & CLASSES
DOGS a unique DOG_ID, DOG_NAME
SHOWS holds a unique SHOW_ID, SHOW_NAME
and CLASSES has a unique CLASS_ID, SHOW_ID, FIRST_PLACE, SECOND_PLACE and THIRD_PLACE.
The CLASSES table holds the DOG_ID value for the dog that won first, second and third place in the respective column.
My problem is, I can do an inner join to show DOG_NAME based on:
select SHOWS.SHOW_NAME, CLASSES.ClassType, DOGS.DOG_NAME
from CLASSES
inner join DOGS ON CLASSES.FirstPlace = DOGS.DOG_ID
inner join SHOWS on CLASSES.Show_ID = SHOWS.SHOW_ID
But how do I get it to show the second place and third place values?
Subject
Written By
Posted
Help with SELECT statement
July 16, 2017 05:40PM
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.