The first to generate you sequence, then
second to populate the main table.
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 12, 2007 8:22 PM
Subject: Re: Insert ... Select troubles
Thanks for the suggestion Brent. The auto_increment won&#
to generate you sequence, then
second to populate the main table.
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 12, 2007 8:22 PM
Subject: Re: Insert ... Select troubles
Thanks for the suggestion Brent. The auto_increment won'
auto increment sequence to be made
for each record "group".
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 12, 2007 12:42 PM
Subject: Re: Insert ... Select troubles
> ItemCount is essentially a counter of the records fr
made for each
record "group".
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 12, 2007 12:42 PM
Subject: Re: Insert ... Select troubles
ItemCount is essentially a counter of the records from the select
statement. So, e
ItemCount is essentially a counter of the records from the select
statement. So, every new INSERT ... SELECT statement gets a new
GroupCount (the next number up) and ItemCount represents the ID of the
items in that new group.
Does that make sense?
- Thanks
>>> "Michael Dykman" <[EMAIL PROTECTE
I need some help creating an INSERT * SELECT statement that supplies a record
counter in the returned items. Here's the task,
I have t1 and t2. t1 is GroupCount, ItemCount, Field1, Field2, Field3. t2 is
Field1, Field2, Field3.
t1 has a multiple field unique key called Request that has Group
