I need to perform this query.
Select firstname, email from dbo.providers where (Active = '1') AND (BIO from dbo.BIOS = '' where dbo.providers ID = dbo.bios ID)
The column ID in dbo.providers is an identity column and also is identical in dbo.BIOS.
I basically want to select the firstname and email from the providers table where their bio is blank in the bios table, and where Active = '1' in the providers table.
I hope this made sense.