Just another Perl shrine | |
PerlMonks |
Re^4: Many-to-many relationships in databasesby Corion (Patriarch) |
on Oct 28, 2005 at 08:25 UTC ( [id://503590]=note: print w/replies, xml ) | Need Help?? |
How does that contradict my statement? The BookAuthors table seems to contain one entry for each pair (book, author), so (in a contrived example) it could look like the following:
The statement will return every book id for the given query of author IN ('Jones', 'Smith'), because, as you say, IN is more or less equivalent to a series of OR statements (I'm not sure about differences regarding NULL values).
In Section
Seekers of Perl Wisdom
|
|