Board index » delphi » insert single column

insert single column

Hi!

how can I insert single column into a table? Like this:

insert into table1 (field1)
values (select field2 from table2)

Thanks
Massimiliano

 

Re:insert single column


insert into mytable(mycolumn)
select anothercolumn from anothertable

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Quote
"Massimiliano Etere" <maxet...@infinito.it> wrote in message

news:3b94a86d_2@dnews...
Quote
> Hi!

> how can I insert single column into a table? Like this:

> insert into table1 (field1)
> values (select field2 from table2)

> Thanks
> Massimiliano

Other Threads