Hi,
Using sqlExpress
I have two tables tblcompany and tblpersonnel. tblcompany.companyid = tblpersonnel.companyid
tblcompany
companyname
companyid
email
tblpersonnel
companyid
firstname
lastname
tblcompany has a company called Booksellers, companyid = 5 and a email address of bWhite@booksellers.com
tblpersonnel has 3 individuals assigned to companyid 5, Sherry Walker, Jim Beam and Barry White.
I can join the tables and pull the company and its corresponding personnel. But..
I only want the person whose lastname matches (like) the lastname in the email address.
Thanks!
Using sqlExpress
I have two tables tblcompany and tblpersonnel. tblcompany.companyid = tblpersonnel.companyid
tblcompany
companyname
companyid
tblpersonnel
companyid
firstname
lastname
tblcompany has a company called Booksellers, companyid = 5 and a email address of bWhite@booksellers.com
tblpersonnel has 3 individuals assigned to companyid 5, Sherry Walker, Jim Beam and Barry White.
I can join the tables and pull the company and its corresponding personnel. But..
I only want the person whose lastname matches (like) the lastname in the email address.
Thanks!