Am I doing a correct way to put the "join relationship" in the whereClause? Or shall I put it elsewhere?
Or should I use "query" instead of "table"?
Um I think you should use a query for this:
<table name="cos">
<field name="customer.id" fieldType="int" size="11"/>
<field name="customer.firstname" fieldType="char" size="50"/>
<field name="orders.order_id" fieldType="int" size="11" isKey="true" autoInc="true" sortable="true"/>
<field name="service.id" fieldType="int" size="11" sortable="true"/>
<field name="service.name" fieldType="char" size="30" sortable="true"/>
<field name="service.description" fieldType="char" size="255"/>
</table>
because customer, orders, and service are all different tables aren't they?
-- Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
