[UPHPU] select records with date

[Joseph Scott]

This is the pre SQL92 ANSI SQL syntax.  Pretty much all of the major
database vendors support the SQL92 syntax now, and most folks use
that.  But if you've been writing SQL queries for awhile then you got
used to writing them in this older style (FROM x, y WHERE x.id = y.id)
and that can be a hard habit to break.


On Thu, Jan 28, 2010 at 9:42 AM, Wade Preston Shearer
<wadeshearer.lists at me.com> wrote:
>> SELECT * FROM Users u, User_Actions ua
>
> I've never seen that syntax (selecting from two tables). Does that just
> default to a right inner join?



-- 
Joseph Scott
joseph at josephscott.org
http://josephscott.org/