Patrick Ige (4/1/2008)

---

i have 3 tables like so below:

table -A

pid mid

--- ----

1 7

2 29

table -B

sid pid mid

--- --- ---

1 1 7

2 1 7

3 2 29

table -C

sid toy

--- ---

1 car

2 ball

3 toy phone

what i want is to loop through table A and C and add values sid,pid and mid into table -B

column sid,pid and mid in table -B isn't auto incremented

Any ideas and thanks in advance