[Koha] Sql report for list of items according to shelving location

[Stefano Bargioni]

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 at 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