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 <saira.asghar23@gmail.com>:

...

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