This is the jest of my query,,
Select *
From Prospecttbl
Where Not Exists(Select * From Membertbl Where Prospecttbl.LastName = Membertbl.LastName and Prospecttbl.FirstName=Membertbl.FirstName)
The two fields have to match identically,, well, ive imported a table where the first name and middle name is merged into one field, which makes this statement null and void,, so i need some help with separating these into two diffent separate field OR another way to match the last name and the first 3 letters of the first name,, HELP!!!
Tesha
Select *
From Prospecttbl
Where Not Exists(Select * From Membertbl Where Prospecttbl.LastName = Membertbl.LastName and Prospecttbl.FirstName=Membertbl.FirstName)
The two fields have to match identically,, well, ive imported a table where the first name and middle name is merged into one field, which makes this statement null and void,, so i need some help with separating these into two diffent separate field OR another way to match the last name and the first 3 letters of the first name,, HELP!!!
Tesha
