Hi everybody,

If I want to insert into the table values from two different selects, is it possible by one command?

something like

insert into myTable (field1, field2) (select ..) (select2)

Both selects return only one row.

I believe it's impossible, we need to do this through variables.

Thanks in advance.