Marty Chiu wrote: > 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
You know how to select with a normal select-statement like select mycol, secondcol from tab1, tab2 where tab1.col10 = tab2.col7 and just put a create view <viewname> as in front of this see reference manual --> data definition --> create view http://www.sapdb.org/htmhelp/6d/117c44d14811d2a97400a0c9449261/frameset.htm Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
