help me in my (select & in) statement

i wanna select inventories inventories table must exist in going_in table

-----------

going_in table

------------------

inventories table 

 

 

 

in example case wanna select inventory (10,2,6) cause exist in going_in table

hi,

select * going_in pk_inventory_id in (select pk_inventory_id inventories)

---

thanks , regards, rishabh

SQL Server  >  Transact-SQL