January 14th, 2004, 04:10 PM
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,
January 14th, 2004, 06:39 PM
Got the query working...Thanks to souls who thought of helping me!