select a.ld_p,a.lastname,firstname,b.orderno from persons a,orders b where a.id_p=b.id_p order by id_o desc
