[eluser]patie[/eluser]
[quote author="WanWizard" date="1280965710"]DMZ determines the names used in the query from the names of the tables, and the relationships defined. The use of the order_user table indicates DMZ sees a many_to_many relationship between user and order.
You need these relations to be defined:
Order must have a has_one to User, User must have a has_many to order.
Order must have a has_many (or a has_one) to Order_album, Order_album must have a has_one to Order
Order_album must have a has_one to Album, Album must have a has_many to Order_album.[/quote]
yes i have exactly what you write
and sql is :
`LEFT OUTER JOIN `user` order_user ON `order_user`.`id` = `order`.`user_id`
must i have NEW table for relation user <> order ??