Member Avatar for John_78

Hello All,

I want to start by saying thank you for your help and reviewing my post. I am relatively new to MySQL and databases in general so please be polite. I need help with some of my queries. I have done some but these are complex queries for me.

Find the movieID, title, and year, and the roleID and roleName in the join between the Movie and Role tables where the value of movieID is the same in both.

Find the roleID, quoteID, and quoteID in the join between the Quote and RoleQuote tables where the value of quoteID is the same in both.

Find all columns of the Cartesian product of the Movie and Role tables.

Find all columns of the Cartesian product of the Quote and RoleQuote tables.

Find the movieID, title, and year of movies, and the roleID and roleName of roles for the join of the Movie and Role tables where the gender of the role is female.

Find the roleID, quoteID, and quoteText in the join between the Quote and RoleQuote tables where the roleID is 00001 or 00003.

Find the movieID, title, and year of movies and the roleID and roleName of roles in the join of the Movie and Role tables. Order the results by the movieID.

  • 3 Contributors
  • 3 Replies
  • 132 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Jack_9

Recommended Answers

All 3 Replies

Member Avatar for John_78

Someone please help i am really despirate.

Member Avatar for Jack_9

He's right. Can we see some code so we can fix it?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.