[Dagger-ACS]

I need help with the correct syntax::
Here is the db Structure:

Table Visitor
Visitor_ID <PK>
FirstName
LastName

Table Attendance
Attendance_ID
Visitor_ID <FK>
Date

I need to know the correct Select statement to return DISTINCT(CONCAT(FirstName, ',' LastName)) AS Name

Where it would return rows from the visitor table where they had no row in the attendance table for a given date. In other words I want to list any visitor who was not there on a specific date. I hope this is clear enough for you guys. My communication skillz are poor...

TIA

Dag