Hello, On Mittwoch, 2. Oktober 2002 05:54, Marty Chiu wrote: > please help > I would like to create a view with joining 3 table > together, but don't know the syntax > sapdb uses standard sql syntax, so select department.fdept, equipment.model, equipment_detail.serial_no from department, equipment, equipment_detail where department.id=equipment_detail.dept_id and equipment.id=equipment_detail.equip_id
should work. You might perhaps have a look at the reference manual for sapdb. Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
