ERROR:  column "bookinfo" does not exist
LINE 1: ...g,( SELECT tdesc from nbh.book_decrptn where bid =BookInfo) ...
                                                             ^

SELECT bid,t_ttl,(select nam from nbh.book_master where id=bid) as bnm,p_pth as path,s_cat,mrp,npg,( SELECT tdesc from nbh.book_decrptn where bid =BookInfo) as dsp,(select nam from nbh.author where id=athr) as aid,(select dsc from nbh.auth_desc where aid=athr) as adsc from nbh.site_book_inf where bid= BookInfo