MySQL reported an error

Query:
SELECT b.*, g.name as group_name,
DATE_FORMAT(b.suggested,'%e/%c/%Y') as `suggested_fdate`,
DATE_FORMAT(b.approved,'%e/%c/%Y') as `approved_fdate`,
DATE_FORMAT(b.deleted,'%e/%c/%Y') as `deleted_fdate`,
UNIX_TIMESTAMP(b.suggested) as suggested_u,
UNIX_TIMESTAMP(b.approved) as approved_u,
UNIX_TIMESTAMP(b.deleted) as deleted_u,
m1.name as suggested_by_name,
m2.name as approved_by_name,
m3.name as deleted_by_name
FROM (hsn_data.books b, hsn_data.courses c, hsn_data.book_groups g)
LEFT JOIN hsn_ipb.ibf_members m1
ON b.suggested_by = m1.member_id
LEFT JOIN hsn_ipb.ibf_members m2
ON b.approved_by = m2.member_id
LEFT JOIN hsn_ipb.ibf_members m3
ON b.deleted_by = m3.member_id
WHERE c.course_name ='Advanced Higher Computing' AND c.dormant = 'FALSE'
AND c.course_name = g.course_name AND b.group_id = g.group_id
AND b.approved IS NOT NULL
AND b.deleted IS NULL

ORDER BY g.group, b.id

MySQL said:
SELECT command denied to user 'hsntest_default'@'localhost' for table `hsn_data`.`books`