SQL mapping of several oracle tables

, ,
1

(Tamino 2.3., Oracle 8i)

Hi,

I have tried to define a data structure (SQL columns) distributed over several oracle tables in one tamino schema. The _define process was successful but XQL-querys ends without results.

Could somebody give me more details on to how this thing was exactly done (e.g. examples)?

Thank you in advance
Jan

2

Jan,

I have attached an Tamino XML Schema which you can find how to link up multiple SQL tables (with primary & foreign key). Although my database was “MS ACCESS”, the concept is the same.
patients.xml (3.08 KB)

3

Hi!

Has anyone tried to link up more than 2 SQL tables?

I have tried with three, by following the example of Tony, but it doesn’t work.

Thanks in advance!