I have two separate data tables I need a sql query to pull data out of$.$

The first table is called Collected$\_$Details and containsa DC$\_$ID column and a Collection$\_$ID column. The DC$\_$ID column contains the names of completed text entryforms and the Collection$\_$ID column contains unique ID numbers generated each time a text entry form has data entered into it$.$

The second table is called Sample$\_$Details and contains a Collection$\_$ID$,$ DCE$\_$ID$,$ Val and Performed$\_$Date columns.The Collection$\_$ID column contains the unique IDs generated from the Collected$\_$Details table. The DCE$\_$ID column containsnames of the entries and the Val column contains the values inputted for those entries. The Performed$\_$DateColumn marks when the entry form was completed.

The sql query needs to have a search field for the DC$\_$ID column from theCollected$\_$Details table. The DC$\_$ID values that will be searched for are $($Gummy$\_$Worm, Gummy$\_$Bear, Taffy$).$Based on the name searched for in the DC$\_$ID column, the query needs to pull out each associated ID number generated from the Collection$\_$ID column. It then needs to take those Collection$\_$ID numbers and search for them in the Sample$\_$Details table Returning the values from the DCE$\_$ID$,$ Val and Performed$\_$Date Columns. Data returned should be ordered by most recent performed date to least recent.

Below is the code i currently have; however it does not work. I am receiving "invalid identifier errors"

SELECTsd.DCE$\_$ID$,$sd$.$Val,sd$.$Performed$\_$Date FROM Sample$\_$Details WHERE sd$.$Collection$\_$ID IN$($ SELECT cd$.$Collection$\_$IDFROM Collected$\_$Details cdWHERE sd$.$DC$\_$ID IN $(\text{'}$CDA$\_$SAMPLE$\_$SUMMARY', $\text{'}$LN$2\_$SAMPLE$\_$SUMMARY', 'HPO$2\_$SAMPLE$\_$SUMMARY'$))$ ORDER BY sd$.$Performed$\_$Date DESC;