Need help on a select statement using MYSQL ^.^

[Sam Lee]

Hi,

I want to create a select statement showing -->

John -- happy -- Alice -- Mad -- Sunday
John -- Mad -- Alice -- happy -- Monday

Here is my table structure:

main (table)
main_id int int primary key
person_id_1 int references person(person_id)
mood_id int references mood(mood_id)
person_id_2 int references person(person_id)
mood_id int references mood(mood_id)
day char(10)

person (table)
person_id int primary key
person_name char(15)

mood (table)
mood_id int primary key
mood_type char(15)

I think my table structure setup is bad....thanks if anyone can help!