I think it is better to use
Stuid
to establish relation between
Studetail
and
Amount
table like
Amount Table
id int,
amount float
in which case the following query can be used to get the result sought in the question
SELECT Studetail.Stuid, Studetail.name, Studetail.college, Stuadd.address,
(SELECT SUM(Amount) FROM Amount WHERE Studetail.Stuid= amount.id) AS TotalAmount
FROM Studetail INNER JOIN Stuadd ON Studetail.Stuid = Stuadd.id