I have 3 tables, 1 table, has data and a 1ID ,table 2 data has the same
some data and 2ID, the 3rd table has the new masterID and Id from the
other table to join all 3 table.
I build a search action and drop in all the colums from the 3 table, "
I have used stored processions For this in the past, or 3 search
action".
Well I used tango and it join, I get all the data ,and it the right data
for what matters, what I don't get it is the master ID from the 3rd
table , but in turn the master ID has to be found first, but yet in
order to get the other table's the master table. Has to found to get the
ID for table 1 and 2. but I don't get the mastered returned to the
resultset, and I know it was used to get the other column table ID's
Make sence
Table 1
ID name data1 data2 data 3
Table 2
ID name data1 data2 data 3
Table 3
masterID table1ID table2ID data1 data2 data
join from master table1ID to table 1 ID
joining from master table2ID to table 2 ID
resultset
"missing mastered" table1ID table2ID 1ID name data1 data2 data 3 2ID
name data1 data2 data 3
just seemed odd
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
