Database

select Dep.Department_Name
from contact_dept Dep
where Dep.Dept_id not in (select Emp.Dept_Id from Contact_Employee_Depts Emp where Emp.Emp_id = 123)
and Dep.active = -1
order by Dep.Department_Name

SELECT job_ticket.job_ticket_id 'Ticket Number',
   job_ticket.subject 'Open Issues', Client.Email
FROM job_ticket
INNER JOIN Client
 ON Client.Client_Id = Job_Ticket.Client_Id
WHERE job_ticket.location_id = '5'
AND status_type_id like '[1-2]'
ORDER BY job_ticket.job_ticket_id

El`Cachubrey wrote:

In my table i have coulmn which should contain customer e-mail address, can i and how if i can
make for this column constraint based on string pattern (is this achived througth
CONSTRAINT Col LIKE '...'????)