• Create VIEW V2 as

    SELECT

    cardno

    , MIN(datetime1) AS MINdatetime1

    , MAX(datetime1) AS maxdatetime1

    ,[action]

    FROM (

    Select * FROM view1)A

    GROUP BY cardno, [ACTION]

    I think this is what you are after.

    you could take it a step more and remove your first view and combine it in this.