Hi Godfrey, you do not specify fields you are interested in. Only some fields from the items table? Or some fields from the bilio table too? Anyway, maybe you can start trying select * from items order by cn_sort or select * from biblio b, items i where b.biblionumber=i.biblionumber order by i.cn_sort and then replace * with a comma delimited list of fields you need to print. HTH. Stefano
> Halo friends, I need technical help in sql, Am at zero level hence I > need your help from scratch. Always grateful. > > Godfrey > > > Quoting Saira Asghar <[email protected]>: > >> Hello Everyone >> >> I need a report for list of items according to shelving location. If anyone >> has this kind of sql report then please send me or help me in generating >> this. >> >> I shall be very thankful for your kind help. >> >> Waiting for reply >> >> -- >> *Regards* >> >> Saira Asghar _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
