To get all similar records

Transact-SQL
1

Hi,
Needed assistance for retrieving the records.

For the below table structure needed CIDS and PartIDS of screws as below
in response

Reference table

ID CID PartID Desc
1 401 75 Screw
2 402 75 Screw
3 403 75 Screw
4 404 78 Needle

Result

              ie,if 403 is passed, needed in return ids
              --------------------------------------------
              **ResultiD    Desc**
              75           Screw
              401          Screw
              402          Screw
              
              
              ------------------------------------------------

Thanks