please help I would like to create a view with joining 3 table together, but don't know the syntax
tables: department: id(pk),fdept equipment: id(pk),model equipment_detail: id(pk),dept_id(fk),equip_id(fk),serial_no relationship: department(1)--(m)equipment_detail(m)--(1)equipment field to be displayed: department.fdept, equipment.model, equipment_detail.serial_no where condition: department.id=equipment_detail.dept_id, equipment.id=equipment_detail.equip_id thanks __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
