What are the relationships between these tables? Are there several ID's in
the first or second table that could match the third table? Try using left
joins instead of the default inner join.
It would be really helpful if you could send us the SQL query Tango
generates. You can find this by clicking on your search action in Tango
Editor and then from the "Window" menu select "SQL Query."
Joanna Ruth Wirtz
Internet Applications Programmer
Christianity Today International
www.ChristianityToday.com
----- Original Message -----
From: "John Hollister" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 7:04 PM
Subject: Witango-Talk: Joining on search actions
> 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
