I use R:Tango 2000 on a Windows 2K server.
I have 2 tables as follows:
Table - Teams
Fields - T_ID, T_Name
Table - Matches
Fields - M_ID, M_Team1, M_Team2
M_Team1 & M_Team2 relate to T_ID in Teams. I want to do a search action of
records in table Matches "joining" T_Name.
In the search action, I list the following under "join"
Match.Team1=Teams.T_ID
Match.Team2=Teams.T_ID
What do I list under "select" to get both names?
Hope this makes sense.
Thanks
Steve Fogelson
Internet Commerce Solutions
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
