>I have two tables, Terror and Htclist. Htc list table contains all the centers and their names. The terror table contains all the errors for each center. How can I run an sql statement that will capture all those records that pertain to the centers that are in the terror table.?

SELECT * ;
  FROM Terror JOIN HctList ON Terror.CenterID = HctList.CenterId ;
INTO CURSOR MyResult