Hi,
Mysql 4.0.14
In a seconrio, some reocrds are missing from a child
table. If we run this query it returns the missing
records:
select a.field1, b.field2 from table1 a left join
table2 b on (a.field1 = b.field1) where b.field1 is
null
I want to create entries in the child table (table2)
fo
Thanks,
I did think of it but not having the option as this is
linked to executables, which I'm sure have some sorts
of calculation for this field to calculate the next
value.
regards
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> > I want to create entries in the child table
> (table2)
>
> I want to create entries in the child table (table2)
> for the missing records. In table2 the primary key is
> of type Integer,
> for each new entry it should be
> Max(table2.PrimaryKeyfield) + 1.
Why not make the primary key in table2 autoincrement? If you have an
autoincrement field as primar
