So I've solved it and it was as simple as pressing few buttons....
Sooo my sql code for my view looks like this now
CREATE VIEW [dbo].[VwMainFaultsWorking]
AS
SELECT f.Symptom, f.symptom2, f.takenby, S.sdesc, S.Ssitenum, f.username, f.phonenumber, f.sectio_, f.sitenumber, f.cleartime...