I am new to sub queries and need some assistance getting this to work.
Here is my statement and I am getting a Msg 102, Level 15, State 1, Line 7
Incorrect syntax near 'lp' message in SQL Server Management
VehicleVIN = (Select lp.ItemName From Loan LoanProperty lp Where lp.MemberNumber=ln.MemberNumber)
ln.LoanType In ('7','27','42','43','1','4','45','47')