Posted by Stanislav V.Pshegoda on 11/16/05 11:35

Hi colleagues
Pls help me. I have very important problem.

I have 3 tables:
tab1 - objects, index field [oid]
tab2 - propertyes, index field [thid]
tab3 - linc table in format: [oid] - [thid], relation -
[great many] to [great many]

How i get table per oid in format
thid | thid.name | status
where:
thid - field [thid] tab2
thid.name - field [name] tab2
status - { =1 if the tab3 contain record [oid] - [thid]
=0, if the tab3 NOT contain record
[oid] - [thid]
}

Tnx

[Back to original message]