ALTER PROCEDURE dbo.usp_profile
@user_id int
AS
Begin
SELECT registration.user_id, registration.firstname, registration.lastname, registration.username, registration.state_id, registration.city_id, registration.pincode,
registration.mobile_no, registration.phone_no, registration.e_mail, registration.address, registration.reg_date, state.state_name, city.city_name
FROM registration INNER JOIN
state ON registration.state_id = state.state_id INNER JOIN
city ON registration.city_id = city.city_id
WHERE registration.user_id = @user_id
End