Select from item table where id from list

Accepted answer

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()))

+1

Nirmal Dayal6y ago

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()))

0

Priyanka Jain6y ago

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()))

+1