trim(Upper(Book_id)) as ID,
Left JOIN (Book)
trim(upper(ID)) as ID,
trim(UPPER([Email Adrress])) As [Email],
Try the out put now.
And yes, if you have multiple emails corresponding to one ID then you will get multiple output.