[no subject]

I'm sure this isn't the answer Christopher wants, and I'm sure who
ever modeled the data had a good reason at the time for storing it
that way. What that good reason may have been, I shudder to think.

The basic rule would be, if you have to think this hard to select the
data you need then the schema is the reason, not the engine.
-G

On 10/3/05, George Carless <kafka at antichri.st> wrote:
> Wrong - you can do joins across multiple databases running on the same
> MySQL server; e.g. select * from db1.users inner join db2.groups on
> users.group_id = groups.group_id ...


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00015" href="msg00015.html">[ale] Selecting from multiple tables</a></strong>
<ul><li><em>From:</em> kafka at antichri.st (George Carless)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00008" href="msg00008.html">[ale] Selecting from multiple tables</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
<li><strong><a name="00010" href="msg00010.html">[ale] Selecting from multiple tables</a></strong>
<ul><li><em>From:</em> meuon at geeklabs.com (Mike Harrison)</li></ul></li>
<li><strong><a name="00012" href="msg00012.html">[ale] Selecting from multiple tables</a></strong>
<ul><li><em>From:</em> kafka at antichri.st (George Carless)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00012.html">[ale] Selecting from multiple tables</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00014.html">[ale] Selecting from multiple tables</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00012.html">[ale] Selecting from multiple tables</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00015.html">[ale] Selecting from multiple tables</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00013"><strong>Date</strong></a></li>
<li><a href="threads.html#00013"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>