Re: Can someone tell me what's wrong with my sql statement ?

[Karen Goh]

Hi IHTH,

First of all, thank you for your reply.

Basically, I am trying to do a insert into a bridging table from table 1 and 2.

Am not sure if this forum is purely just for sql syntax cos I have included some java programming code.

I hope you can tell me the way to do it.

I am able to insert into table 1 and 2 but what should be the sql for inserting into the bridging table ? Do I just join or ?