Goran Bibic

Goran Bibic

  • 687
  • 2.1k
  • 44.8k

Select from item table where id from list

Nov 19 2019 4:20 AM
I have multiple value
  1. SELECT * FROM DBO.mp_racun_roba  WHERE id_fakture=(select * from mp_racun_lista where datum=CONVERT(date,GETDATE())) 
I have error in second line please help
 
Msg 116, Level 16, State 1, Line 3
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

Answers (3)