Sorry not real familar with MYSQL syntax yet but I think you'll be able to translate.
select m.magazinename from s,m,b where s.name = 'fred' and s.id=b.subscriberid and m.id=b.magazineid ; On Wed, Jan 23, 2002 at 03:59:11PM -0700, Christopher Thompson wrote: > At 02:51 PM 1/23/2002 -0800, you wrote: > >i understand that creating a M:N relationship in mysql involves 3 tables, > >one of which being a bridge, but how do i join the first and third tables > >by way of a bridge? > > > > example: a table of subscribers and a table of magazines with a bridge > > in the middle. how do i select just the magazines fred is subscribed to? > > thanks in advance and sorry if this is a confusing question. > > Table S (subscribers) > ID > Name > > > Table M (magazines) > ID > MagazineName > > > Table B (bridge) > SubscriberID > MagazineID > > > Sample data in S: > 1 - Fred > 2 - John > 3 - Chris > > Sample data in M: > 1 - Playboy > 2 - Computer Gaming World > 3 - Maxim > > Sample data in B: > 1 - 1 > 1 - 3 > 2 - 1 > 2 - 2 > 3 - 2 > > How do you select just the magazines Fred subscribes to? SELECT > MagazineName FROM M, B WHERE M.ID = B.MagazineID AND B.SubscriberID = > (Fred's ID); > > Or something. My SQL is a little rusty, it's been about six months since I > used it last. > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
