Inserting into Table A based on a value in Table B, How?

[KelleyB623]

I need to insert rows into Table A based on a value in Table B. I als need a column in Table B to populate one of the values during the insertions. I've tried joining and subqueries but can't seem to get it to work.

Is this type of insert possible and if so, what is the syntax?

Thanks in advance.

 

[qyllr]

hello,

try using a trigger...

hth,
q.

 

[JeanNiBee]

Hi

Try this..

INSERT authors (firstName, lastName)
SELECT newAuthors (firstName, lastName)
^-- this is all ONE command.


The column sequence in the two tables MUST match if you wish to use the "*" char in the SELECT part of the command, and use only the table name in the INSERT part of the command.





-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[johnvai]

Dear Friend:
Can you give some realistic table and field names to know what to do.
usually it is too easy.