SELECT MB.*,MP.PB_NAME,MBT.BT_ID,MBT.BT_NAME,MAN.AN_NAME,CGR_NUMBER,CGR_MAIN_ID FROM M_BOOKS MB
LEFT JOIN M_PUBLISHER MP ON MB.B_PUBLISHER = MP.PB_ID
LEFT JOIN M_BOOKTYPE MBT ON MB.B_TYPE = MBT.BT_ID
LEFT JOIN M_CATEGORY C ON MB.B_GROUP = C.CGR_ID
JOIN M_AUTHORNAME MAN ON MB.B_NUMAUTHOR = MAN.AN_ID WHERE B_ID =Error Description: ORA-00911: invalid character