At 06:32 AM 1/1/03 -0500, David T-G wrote:
I still don't get what a left or right or outer or inner join is...
The reason I chose LEFT JOIN are:
o You get better control over how the query is executed.
o Values from the first table are returned even if there is no associated
entry in the sec
% different ways of connecting tables with LEFT JOIN. USING( fieldname )
% connects the table being joined, with the table listed right before it,
% using the same fieldname in both. The ON syntax allows you to use
% differently named fields, and/or a different table.
I still don't get what
Rick, et al --
...and then Rick Widmer said...
%
% At 02:57 PM 12/31/02 -0500, David T-G wrote:
% >...and then Tularis said...
% >%
% >% Usually,
% >% using mysql to handle your tables is *way* faster than letting php
% >% handle it.
%
% Yes, do as much as you can in the database. The people wh
At 02:57 PM 12/31/02 -0500, David T-G wrote:
...and then Tularis said...
%
% Usually,
% using mysql to handle your tables is *way* faster than letting php
% handle it.
Yes, do as much as you can in the database. The people who wrote it spent
a lot of time trying to optimize it.
%
% In your
Tularis, et al --
...and then David T-G said...
%
% ...and then Tularis said...
% %
% % Usually,
% % using mysql to handle your tables is *way* faster than letting php
% % handle it.
...
% %
% % In your case, you could just do a complex join I think. That would give
%
% Ahhh... A new term.
Tularis, et al --
...and then Tularis said...
%
% Usually,
% using mysql to handle your tables is *way* faster than letting php
% handle it.
Hmmm... OK. But that's so many queries... "Or is it?", he asks,
reading farther.
%
% That's what it was made for, speed...!
Well, yeah, I figured t
Usually,
using mysql to handle your tables is *way* faster than letting php
handle it.
That's what it was made for, speed...!
In your case, you could just do a complex join I think. That would give
all results in one table, and you could just order that on scheduletime,
and voila, you'd have
7 matches
Mail list logo
