statement return empty fields [message #1457612] |
Fri, 31 October 2014 14:09 |
Ihar Rubanovich Messages: 3 Registered: October 2014 |
Junior Member |
|
|
Good day.
I have statment :
select public.warehouse_item_types.title, public.warehouse_item_units.code,
public.warehouse_document_operation_entries.amount,public.warehouse_document_operation_entries.price,
public.warehouse_document_operation_entries.cost,public.vat_rate.value,public.warehouse_document_operation_entries.sum_vat_rate,
public.warehouse_document_operation_entries.cost_with_vat
from public.warehouse_item_types, public.warehouse_item_units,public.warehouse_document_operation_entries,public.vat_rate
where public.warehouse_item_types.id in
(select public.warehouse_operation_entries.warehouse_item_type_id
from public.warehouse_operation_entries
where public.warehouse_operation_entries.warehouse_operation_id in
(select public.warehouse_outgoing_goods_waybill.warehouse_operation_id
from public.warehouse_outgoing_goods_waybill
where public.warehouse_outgoing_goods_waybill.id = 493))
and public.warehouse_item_units.id = public.warehouse_item_types.units_id
and public.warehouse_document_operation_entries.warehouse_item_type_id = public.warehouse_item_types.id
and public.vat_rate.id = public.warehouse_document_operation_entries.vat_rate_id
It work , if I run it in PgAdminIII. But in Eclipse result is empty fields. How to adapt this statement for my report ?
|
|
|
|
Powered by
FUDForum. Page generated in 0.02727 seconds