Please specify the table name on where query not on select like this where (CHECKINOUT.CHECKTIME >= @PARM) the full code is here SELECT TABLE_NAME1.COLUMN.NAME1,TABLE_NAME2.COLUMN.NAME1,TABLE_NAME2.COLUMN.NAME2 FROM TABLE_NAME1 INNER JOIN TABLE_NAME2 ON TABLE_NAME1.COLUMN.NAME1 = TABLE_NAME2.COLUMN.NAME1 where (TABLE_NAME1.COLUMN.NAME1 >= @PARM) GROUP BY TABLE_NAME1.COLUMN.NAME1,TABLE_NAME2.COLUMN.NAME1,TABLE_NAME2.COLUMN.NAME2 cmd.Parameters.AddWithValue("PARM", dtCheckTime.Value);

Thanks https://stackoverflow.com/users/1736047/stldev you answered the question correctly.