MySQL reported an error

Query:
SELECT l.*, g.name as group_name,
DATE_FORMAT(l.suggested,'%e/%c/%Y') as `suggested_fdate`,
DATE_FORMAT(l.approved,'%e/%c/%Y') as `approved_fdate`,
DATE_FORMAT(l.deleted,'%e/%c/%Y') as `deleted_fdate`,
UNIX_TIMESTAMP(l.suggested) as suggested_u,
UNIX_TIMESTAMP(l.approved) as approved_u,
UNIX_TIMESTAMP(l.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.links l, hsn_data.courses c, hsn_data.link_groups g)
LEFT JOIN hsn_ipb.ibf_members m1
ON l.suggested_by = m1.member_id
LEFT JOIN hsn_ipb.ibf_members m2
ON l.approved_by = m2.member_id
LEFT JOIN hsn_ipb.ibf_members m3
ON l.deleted_by = m3.member_id
WHERE c.course_name ='Higher Business Management' AND c.dormant = 'FALSE'
AND c.course_name = g.course_name AND l.group_id = g.group_id
AND l.approved IS NOT NULL
AND l.deleted IS NULL

ORDER BY g.group, l.id

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