shahnid k

shahnid k

  • NA
  • 61
  • 15.6k

Select query inside Insert Query.

Feb 5 2017 6:43 AM
  1. insert into ACCESS_DETAILS(USER_ID,GROUP_ID,COMPANY_ID) values (1111,11, (select COMPANY_ID from GROUP_COMPANY_CONFIG where GROUP_ID = '1'))  
In the above query, the subquery is returning more than one values. so how can i insert it into the table without error. 

Answers (5)