Extended report queries

unknown

Can I select fields from more than one table in extened report queries, if I can, what does the 'select' command look like?

unknown

Yes, you can select fields from more than one table. Below is an extended query pulling from the customer order and shipper tables. This should be enough to put yo on the right path. Good Luck

SELECT CUSTOMER_ORDER.USER_1 , CUSTOMER_ORDER.USER_3 , CUSTOMER_ORDER.USER_4 , SHIPPER.WAYBILL_NUMBER FROM CUSTOMER_ORDER , SHIPPER WHERE CUSTOMER_ORDER.ID = :CO_ID AND SHIPPER.PACKLIST_ID = :CO_PACKLIST_ID