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:
>
>
>
> >>
> >>
> >> Why the LEFT JOINS ?
> >> They're (mostly) used for finding set membership; whenever you see
> >> 'LEFT JOIN b' without s fo
On 11-Jul-01 Mike W. Baranski wrote:
> Awsome answers! I'll clear a few things up where appropriate
>
> Don Read wrote:
>>
>>
>> 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 t
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 badge_h
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, ba
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, badge_history.xact_time AS xact_time, badg
