insert 2 select sql result into one insert sql

Question

i have a table with 2 fields. How can i insert those 2 fields from result of 2 sql result.

 insert into access (user,page)
(select id as user from users where id =5,
select pagename as page from pages where id =10)

There is no relation between 2 tables . i dont think i can join .

Is there any sort of relationship between users and pages? Can you give some sample data to show what you're trying to do? — Jeff Rosenberg
– Jeff Rosenberg, Commented Apr 12, 2013 at 17:30

zod · Accepted Answer · 2013-04-12 17:42:29Z

1

insert into access ("user", page) values
(  (select id as user from users where id =5),
   (select pagename as page from pages where id =10)
)

zod

12.5k25 gold badges74 silver badges107 bronze badges

answered Apr 12, 2013 at 17:32

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ihor Romanchenko · Accepted Answer · 2013-04-12 17:43:50Z

1

insert into access (user,page)
select users.id as user, 
       pages.pagename as page 
from users,pages
where users.id = 5
  and pages.id = 10

answered Apr 12, 2013 at 17:43

Ihor Romanchenko

29k9 gold badges56 silver badges45 bronze badges