I have multiple value 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.

Here you are comparing one column " id_fakture " with all columns. ( select * from mp_racun_lista where datum= CONVERT ( date ,GETDATE())) this line will return all columns, instead of using "*" you need to specify column name which you want to compare. Also if result of subquery will return more than 1 value then use "IN" instead of "=" please see below SELECT * FROM DBO.mp_racun_roba WHERE id_fakture IN ( select COLUMNNAME from mp_racun_lista where datum= CONVERT ( date ,GETDATE()))

Try using IN operator instead of = and also you need to specify single column while using in subquery like below SELECT * FROM DBO.mp_racun_roba WHERE id_fakture IN ( select Id from mp_racun_lista where datum= CONVERT ( date ,GETDATE()))

Hi Goran, List of collection pass in where clause always use "IN" SELECT * FROM DBO.mp_racun_roba WHERE id_fakture in (select * from mp_racun_lista where datum=CONVERT(date,GETDATE()))