尝试使用JOIN：

SELECT tab1.ID，tab1.Value，tab2.Value
FORM Table1 tab1
JOIN 表2 tab2
ON tab1.ID = tab2.IDInTable1
WHERE tab2.SelectOnThis = 666

如果不了解更多关于各种表格以及它们如何互连的信息，我可以;不会给你任何确切的SQL你的确切需求，但这应该给你一个想法。

I Want to fetch Record from Four tables Named AS Book_Master,BookIssue_Master,BookEntity_Master,Penalty_Master Having Foreign key BI_SerialNo,BE_SerialNo,BK_SerialNo
But My Query unable to Fetch Required data. My Query is follows

SELECT BK_BookName,BK_BookPublication,BK_SerialNo,BI_SerialNo,BI_BookEntityID,
BI_BookIssueDate,BI_BookReturnedOn,PN_BookIssueID,PN_SerialNo,PN_BookIssueID,
PN_PenaltyAmountInWords,BE_SerialNo,BE_BookID FROM Book_Master,BookIssue_Master,
BookEntity_Master,Penalty_Master WHERE BI_SerialNo=PN_BookIssueID
AND BI_BookENtityID=BE_SerialNo
AND BE_BookID = BK_SerialNo
AND BI_IsPenalty IN('N')

It Fetches All data From Database tables,Please Suggest me to get required data

Try using a JOIN:

SELECT tab1.ID, tab1.Value, tab2.Value
FORM Table1 tab1
JOIN Table2 tab2
ON tab1.ID=tab2.IDInTable1
WHERE tab2.SelectOnThis=666

Without knowing a lot more about your various tables and how they are interconnected, I can;'t give you any exact SQL for your precise need, but that should give you the idea.