hi
i have 3 table in my database
Trade Table
T_code
|
Name
|
Keyword
|
1
|
Hotel
|
Hote
|
1
|
Hotel
|
Travel
|
1
|
Hotel
|
Room
|
2
|
Training
|
English
|
2
|
Training
|
Sport
|
hotel table
T_code
|
HotelName
|
HotelAddress
|
HotelTell
|
1
|
Milan
|
Germany
|
32436565
|
1
|
Paris
|
Franch
|
25435863
|
1
|
Italy
|
Veniz
|
3685686
|
training table
T_code
|
trainingName
|
Address
|
tell
|
2
|
English
|
Germany
|
53434646
|
2
|
Computer
|
Franch
|
25435863
|
2
|
Sport
|
Veniz
|
254
|
i want when user write keyword that exist in trade table it connect to table that is in keyword rows
EX: user write room in TB and click search button it will connect to Hotel table and show hotel table columns
i dont know how i can make relation between trade-hotel-training Tables?