Joins in SQL

Dear Friends,

Some time we got problems in views , when we run default views it shows all records from both the table, if we want only records from one table always use RIGHT JOIN or LEFT JOIN
it will shows only one table record.

if you want to show all records (Not only matching records) use Right join or Left Join

Sample View

SELECT dbo.view_DistCommission.

inttransectioncode AS Expr3, dbo.mstreport.ReferenceNo, dbo.mstreport.MerchantID AS Expr2,
dbo.view_DistCommission.intrdsbooking, dbo.view_DistCommission.transectiondate, dbo.view_DistCommission.distributorcode,
dbo.view_DistCommission.customername, dbo.view_DistCommission.strstatus, dbo.view_DistCommission.createddatetime,
dbo.view_DistCommission.Expr1, dbo.view_DistCommission.strAgencyName, dbo.view_DistCommission.b2cdistributortac,
dbo.view_DistCommission.b2cagenttac, dbo.view_DistCommission.transectionstatus, dbo.view_DistCommission.offerprice,
dbo.view_DistCommission.agentcode, dbo.view_DistCommission.publishedprice, dbo.view_DistCommission.Description,
dbo.view_DistCommission.product, dbo.view_DistCommission.strmerchantcode, dbo.view_DistCommission.merchantid,
dbo.view_DistCommission.TDS, dbo.view_DistCommission.inttransectioncode
FROM dbo.view_DistCommission LEFT OUTER JOIN
dbo.mstreport ON dbo.view_DistCommission.inttransectioncode = dbo.mstreport.strtransectionid
GROUP BY dbo.view_DistCommission.inttransectioncode, dbo.mstreport.ReferenceNo, dbo.mstreport.MerchantID, dbo.view_DistCommission.intrdsbooking,
dbo.view_DistCommission.transectiondate, dbo.view_DistCommission.distributorcode, dbo.view_DistCommission.customername,
dbo.view_DistCommission.strstatus, dbo.view_DistCommission.createddatetime, dbo.view_DistCommission.Expr1,
dbo.view_DistCommission.strAgencyName, dbo.view_DistCommission.b2cdistributortac, dbo.view_DistCommission.b2cagenttac,
dbo.view_DistCommission.transectionstatus, dbo.view_DistCommission.offerprice, dbo.view_DistCommission.agentcode,
dbo.view_DistCommission.publishedprice, dbo.view_DistCommission.Description, dbo.view_DistCommission.product,
dbo.view_DistCommission.strmerchantcode, dbo.view_DistCommission.merchantid, dbo.view_DistCommission.TDS

Thanks
Pradeep Deokar