You need to explicit Join all the tables, A with B, B with C, C with D, or whatever relation you have.
>Hello again! I am trying to expand this process that I asked about earlier and trying to figure out this will not let me accomplish the following: select a.inv_no, b.account_no, b.location, c.product_desc, d.acc_name ;
from order_file a inner join ship_history b, product_items c, customer_accounts d ;
on a.inv_no=b.inv_no ;
into cursor sql_data
As stated in an earlier post:
>I am trying to get last record information from a table. This process uses two tables: 1 parent table and 1 child table. The data is going to a report.
>The parent tables hold five fields, one of which is an order number field
>The child table holds 50 fields, the two relevant fields are:
1. order number
2. order status
>The tables appears as:Parent Child
Order number Order Number Order Status
11111 11111 Submitted
11121 11111 Processing
11131 11111 Shipped
11121 Hold
11131 Submitted
11131 Processing
11131 Cancelled>Now I am trying to add a few fields from other tables. I am trying to bring in the associated account name that is from the parent order number and I am trying to bring the product description from the product file.
