How do i change this statement that filters what we show on our datagrid?
what we want to do is,Code:commEmployee.CommandText = "SELECT EmployeeID 'Employee ID', EmployeeFName 'First Name', EmployeeLName 'Last Name' FROM EmployeeProfile;"
SELECT only the EMPLOYEES that does not have a similar EmployeeID on another table..
ex.
Employee table has an EmployeeID field
Attendees table has an employeeID field
what we want to select are the Employees that do not have a similar employeeID on the attendees table? is this possible on an SQL statement?




Reply With Quote