USE LibraryBorrower22
GO
SELECT B.BookId,BC.BookId,BL.BookId,BL.CardNo,BO.CardNo
FROM Book_Copy AS BC
INNER JOIN Book_Loans AS BL
ON BL.BookId=BC.BookId
WHERE BC.No_Of_Copies>5
UNION
SELECT B.BookId,BC.BookId,BL.BookId,BL.CardNo,BO.CardNo
FROM Book_Loans AS BL
INNER JOIN Borrower AS BO
WHERE BO.Name
AND BO.[Address]
Has the following error Code. I assume I’m using a UNION correctly?
I used a UNION statement, to join 2 SELECT statements, as it seemed easiest.
However, it seems that the BO.Name, and BO.Address are a problem. I’ve tried a number of things, both removing info, and adding ‘>5’ on each, but I’m guessing at this point, and not really learning.
Suggestions?
I got the following error code:
Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword ‘WHERE’.