Friday, June 22

Join Three Tables Using Sql Query

Here i have used three tables as shown below

Data of My Table Looks like this:-

Sql Query as:-

SELECT        FName
FROM            FTable
WHERE        (FID =
                             (SELECT        T2.FID
                               FROM            TTable AS T2 INNER JOIN
                                                         PTable AS T1 ON T2.PID = T1.PID
                               WHERE        (T1.PID = 1)))

Thanks Shibashish mohanty

No comments:

Post a Comment

Please don't spam, spam comments is not allowed here.

shibashish mohanty