Don Read wrote:
On 11-Jul-01 Mike W. Baranski wrote:
Awsome answers! I'll clear a few things up where appropriate
Don Read wrote:
snip
Why the LEFT JOINS ?
They're (mostly) used for finding set membership; whenever you see
'LEFT JOIN b' without s following 'b IS [NOT]
On 11-Jul-01 Mike Baranski wrote:
I was wondering if anyone had any suggestions on the following problem. I
have a table with about 7 million rows, and I'm using the following
join:CREATE TABLE badge_history_resolved SELECT badge_history.id AS id,
badge_history.xact_date AS xact_date,
Awsome answers! I'll clear a few things up where appropriate
Don Read wrote:
On 11-Jul-01 Mike Baranski wrote:
I was wondering if anyone had any suggestions on the following problem. I
have a table with about 7 million rows, and I'm using the following
join:CREATE TABLE
On 11-Jul-01 Mike W. Baranski wrote:
Awsome answers! I'll clear a few things up where appropriate
Don Read wrote:
snip
Why the LEFT JOINS ?
They're (mostly) used for finding set membership; whenever you see
'LEFT JOIN b' without s following 'b IS [NOT] NULL' clause 'tis the