[no subject]

We have this system in our application where we divide mulitple
Organiations into their own separate databases.  Each database has the
same schema  but the data is different.  I need the ability to see all
the alarms in the alarm table fro all organizations.  Normally I would
simply use 'use AC_DEMO; select * from alarm;'  In this case I need to
do something like 'select * from AC_DEMO.alarm, AC_WIP.alarm;'  The
reason I want to do it in the select and not in the application is
because we heavily use SQLs ability to sort and order the data.  So to
see all the alarms raised in order by date I would simply append 'order
by raised'.

This is not a simple join where you join tables by keys.  This is where
I want to select all the data from many tables that are the same.  Is
this possible?



</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<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="00014" href="msg00014.html">[ale] Selecting from multiple tables</a></strong>
<ul><li><em>From:</em> mmillson at meritonlinesystems.com (Mike Millson)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00007.html">[ale] request for Linux expert</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00009.html">[ale] request for Linux expert</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00011.html">[ale] request for Linux expert</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00010.html">[ale] Selecting from multiple tables</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00008"><strong>Date</strong></a></li>
<li><a href="threads.html#00008"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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