Thanks for the response. Here are the scripts for the above

I am new sql server. I am trying to get the following data. I have 3 different tables

create table table1(conid int,location varchar(3))

insert into table1 values(1,'CVG')

insert into table1 values(2,'DAY')

insert into table1 values(3,'CMH')

go

create table table2(conid int,cert varchar(5),certdate varchar(10))

insert into table2 values(1,'cert1','01/01/2001')

insert into table2 values(1,'cert2','02/03/2008')

insert into table2 values(1,'cert3','01/01/2012')

insert into table2 values(2,'cert2','02/02/2012')

go

create table table3(certid int,certdesc varchar(5))

insert into table3 values(1,'cert1')

insert into table3 values(2,'cert2')

insert into table3 values(3,'cert3')

insert into table3 values(4,'cert4')

go

I neeed to find all those conids who do not have cert1, cert2, cert3, cert4 in table2. The total required certs are in table3.

Here is the sample data, I am looking for

conid location certdate certdate certdate certdate

1 CVG 01/01/2001 02/03/2008 01/01/2012 NULL

2 DAY NULL 02/02/2012 NULL NULL

This indicates that conid 1 should still have cert4 and conid = 2 should have cert1date, cert3date and cert4date.

I need to create a report that have a date and also those ids who still do not have a date in the system.

Any help on this is greatly appreciated.