[no subject]

H*ll no!  MySQL is all I use.  Unless it is SQLlite.

> 
> What's wrong with a join?
> 
> select * from users inner join ALARMS on users.user_id = ALARMS.user_id WHERE ALARMS.ID=1;
> 
> Using nested SELECT statements when a join is the right tool for the job is.. nasty.
> 
> Cheers,
> --George
> _______________________________________________
> Ale mailing list
> Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00018" href="msg00018.html">[ale] MySQL Question</a></strong>
<ul><li><em>From:</em> Jerry.Yu at Voicecom.com (Yu, Jerry)</li></ul></li>
<li><strong><a name="00026" href="msg00026.html">[ale] MySQL Question</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="msg00027.html">[ale] MySQL Question</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00029.html">[ale] HTML -&gt; PS -&gt; PDF</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00026.html">[ale] MySQL Question</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00023.html">[ale] SGI Altix 256 CPUs Single Kernel</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00028"><strong>Date</strong></a></li>
<li><a href="threads.html#00028"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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