How I get the record of two table which don't have foreign key relationship?

Hi Anyone can help me to solve this problem

I have 3 tables FundsPlanning , GradeMst and SupplierMst

I want column SupplierId, WeightLoaded, DeliveryDate, InvoiceAmount, GradeName
like this way.

But the problem is there is no relationship between FundsPlanning and GradeMst.

So the GradeName column exists in GradeMst table.

There is also one table PurchaseContract which has a foreignkey relationship with
SupplierId and GradeId so I can find the Id of Grade.

Using below query I can get the record of Grade column

SELECT GradeId, Grade 
FROM GradeMst 
WHERE GradeId In (SELECT Gradeid FROM PurchaseContract WHERE SupplierId=2)

Using below query I can find the SupplierId, WeightLoaded, DeliveryDate, InvoiceAmount.

SELECT FP.SupplierId,SM.SupplierId,FP.WeightLoaded,FP.DeliveryDate,FP.InvoiceAmount 
FROM FundsPlanning FP
INNER JOIN SupplierMst SM
ON FP.SupplierId=SM.SupplierId and SM.SupplierId=2

How can I combine the result set of these two tables?

You could try to join all tables, but you need to take care of the relationships between tables (1-1, 1-many, many-many) because you could end up getting duplicate rows

SELECT
    FP.SupplierId,
    SM.SupplierId,
    FP.WeightLoaded,
    FP.DeliveryDate,
    FP.InvoiceAmount,
    GM.GradeName
FROM FundsPlanning FP, 
    SupplierMst SM,
    PurchaseContract PC,
    GradeMst GM
WHERE 
    FP.SupplierId = SM.SupplierId 
    AND PC.SupplierId = FP.SupplierId
    AND GM.GradeId = PC.GradeId
    AND SM.SupplierId = 2