[ale] MySQL Question

[George Carless]

On Thu, Apr 01, 2004 at 09:15:12AM -0500, James Sumners wrote:
> As far as I understand it subqueries are not available until 4.1 which is not a
> production release.
> 
> SELECT * FROM users LEFT JOIN alarms ON users.id=alarms.id WHERE alarms.id='1';
> 
> http://www.mysql.com/doc/en/JOIN.html

Note that you'd want an inner join in this case, though, not a left join.  And even if you *do* have a MySQL release that supports 
subqueries, you really shouldn't use them for this kind of thing.

Cheers,
--George