January 14th, 2004, 03:10 PM
Join Date: Dec 2003
Time spent in forums: < 1 sec
Reputation Power: 0
INSERT and SELECT SQL Query
I am in a crisis now,please help...I have a query that returns multiple records from a table.
I have to insert this entire dat into another table that does not have the same struture as the first table.
below is my query:
INSERT INTO assoc_word ( assoc_word_root, assoc_word_alternate, type)
( select trade_name from drugs where trade_name != chemical_name),
( select chemical_name from drugs where trade_name != chemical_name),
the select actually returns a chunk of data from drugs table that i have to use to populate the assoc_word table.
This is very urgent!Any help ASAP would be appreciated
Many thanks in advance,