Let’s say we have 2 tables with Many to many relationship?
Actors and Movies. Actors can be in many movies and movies have many
actors.
I want a query that does a text search on the Movie name and finds all
movies with the word “Shark” in it. The result page would be a list
sorted by Movie Title/Actor name like:
Movie Actor
Sharks Rule Barnes, Oscar
Sharks Rule Cole, Tony
Sharks Rule Kentz, Olivia
Teasing Sharks Hardy, Fool
Teasing Sharks Trouble, Wanting
I only want 25 Movie/Actor lines per page. Any good samples for getting
this done?
Regards