sql - SELECT statements as INSERT parameters along with other parameters

Question

Both of the SELECT statements return only one scalar data each. I wish to pass them as the first two parameters of the INSERT statement. But it's throwing an error stating invalid comma after the second SELECT statement. What am I doing wrong here?

INSERT INTO messages(src_id, tar_id, body, time)
         SELECT id FROM chatters WHERE (uname = 'adnan'),
       SELECT id FROM chatters WHERE (uname = 'john'), 'Hello John', '1971-12-16';

question from:https://stackoverflow.com/questions/65931899/select-statements-as-insert-parameters-along-with-other-parameters

Answer 1

Put the whole SELECT in brackets:

INSERT INTO messages(src_id, tar_id, body, time)
   VALUES
  ( ( SELECT id FROM chatters WHERE (uname = 'adnan') ),
   ( SELECT id FROM chatters WHERE (uname = 'john') ),
   'Hello John',
   '1971-12-16' );