MySQL Forums
Forum List  »  Newbie

Help with SELECT statement
Posted by: Gareth Cross
Date: July 16, 2017 05:40PM

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?

Options: ReplyQuote


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.