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.

.

ShibashishMnty
shibashish mohanty