SELECT b.bk_id
                                    FROM cni_view_internal_broker b
                                    INNER JOIN cni_view_yacht y ON b.bk_id = y.id_broker
                                    WHERE y.yref = 
                                    <br />You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3