"adrian Greeman" <[EMAIL PROTECTED]> wrote:
> There is a particular form of SQL query you can use I believe when you
> are adding data to a table and want to include an ID number from another
> lookup table but you only know the name reference and not the ID
>
> eg it might be an "author" table wi
Adrian,
You may try this:
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
Best Regards,
Jonathan Chiu
OOCL Logistics
Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai
TEL: 852 . 2990 0174
FAX: 852 . 28249017
-
