I have the following Select statement, but want to change it to use iner joins as I believe they are more efficient, but not too sure where to start.
DECLARE @myNameID int
DECLARE @myAddressID int
DECLARE @myFirstName nvarchar(256)
SET @myNameID = 1
SET @myAddressID =1
SET @myFirstName='Nathan'
SELECT @myNameID = myNameID
FROM
NameTable Name,
AddressTable Address,
CountryTable Country
WHERE
Name.[FirstName] = @ myFirstName and
Address. AddressID = @ myAddressID and
Address.CountryID = Country.CountryID and
Name.SecondID = Country.SecondID