FROM Book_Copy AS BC
INNER JOIN Book_Loans AS BL
FROM Book_Loans AS BL
INNER JOIN Borrower AS BO
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.
I got the following error code:
Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword 'WHERE'.