SELECT books.*

FROM books

INNER JOIN ordered_items

ON books.bk_no = ordered_items.bk_no

GROUP BY books.bk_no

HAVING COUNT(ordered_items.bk_no)>2

ERROR MSG:Msg 8120, Level 16, State 1, Line 1

Column 'books.title' is invalid in the select list because it is...

Yeah, home work in the sense that am practicing on my own - self study.

I could understand the concept of the join statement, but still couldnt get the results i wanted.

to make it easier these are the scripts am using, and what i want...