Query Access Question
This answer presumes there is no many to many table with BidId related to ContractorId which should probably exist.  Examples of the tables from which you are querying are as helpful as seeing the example of expected result.

DECLARE @BidId int = 1

    SELECT BidID, ContractorName, ContractorEmail 
    FROM tblBids B
    JOIN tblContractors C
    ON B.ContractorId = C.ContractorId 
    WHERE B.BidId = @BidId