var pb = from d in pr.Purchases join b in br.Books

                                           on d.bookID equals b.bookID

                                           where d.pUserID == userID && d.sta != "2"

                                           orderby d.pTime descending

                                           select new PurchaseBook {

                                               pID = d.pID, 

                                               bookID = d.bookID,

                                               bookName = d.bookName,

                                               pUserID = d.pUserID,

                                               pUserName = d.pUserName,

                                               sta = d.sta,

                                               pTime = d.pTime,

                                               ZT = d.ZT,

                                               sUserID = d.sUserID,