Let's say I have the following 3 tables: customer purchase order purchase order lines
Each purchase order line has a reference to a purchase order. Each purchase order has a reference to customer. I want to do a query where I retreive all purchase order lines sorted by customer name (among other things). When I try this, OJB handles the join between purchase order lines and purchase order, but doesn't join the customer table. Is there a way I can force it to include the customer in the query? When I did the addOrderBy, I specified "purchaseorder.customer.name" but when OJB created the SQL, it changed that to "name", but didn't specify an alias for the field and didn't include customer in the from or where clauses. It did join the purchase order lines and the purchase order table. Thanks Jay --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]