Problems? Is your data what you think it is? | |
PerlMonks |
Re: Many-to-many relationships in databasesby davorg (Chancellor) |
on Oct 28, 2005 at 08:51 UTC ( [id://503596]=note: print w/replies, xml ) | Need Help?? |
This is really off-topic for this site, but let's have a go anyway. You need to join the BookAuthor table with itself. I'm old-skool so I do joins in the WHERE clause, but there's probably a simpler way to do it using an explicit JOIN clause.
Update: The JOIN syntax looks like this:
You should be able to omit the "INNER", but I was testing on a rather old version of MySQL which didn't support the abbreviated syntax.
-- <http://dave.org.uk> "The first rule of Perl club is you do not talk about
Perl club."
In Section
Seekers of Perl Wisdom
|
|