On Oct 10, 2009, at 8:18 PM, Gavin Kistner wrote: > On Oct 10, 2009, at 4:22 PM, Christer Nilsson wrote: >> Database A: >> >> Humans >> ID >> Name >> >> Database B: >> >> Pets >> ID >> Owner_ID >> Name >> I would like to know the names of all humans with pets named Ajax. >> >> SELECT A.Humans.Name >> FROM A.Humans >> JOIN B.Pets ON B.Pets.Owner_ID = A.Humans.ID >> WHERE B.Pets.Name = 'Ajax' > > These aren't two separate databases, they're two separate tables.
Bah. Please ignore what I wrote. Apparently I can't read. You are, of course, talking about two separate databases and not just two tables in the same DB. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
