At 9:41 AM -0400 9/1/09, Andy Dirnberger wrote:
On Tue, Sep 1, 2009 at 8:58 AM, tedd <[email protected]> wrote:

I need to understand joins much better than I do now because the first query I fully understand while the second I don't.


Think of the WHERE clause as the filter.  Use it to place restrictions
on what information is returned.

WHERE price > 50 AND color = 'red'

I fully understand WHERE, it's understanding how JOIN's simplify things.

Cheers,

tedd

--
-------
http://sperling.com  http://ancientstones.com  http://earthstones.com
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

http://www.nyphp.org/show_participation.php

Reply via email to