Dear All.
1. I need to select all related information from a table (lesson) that fulfill certain conditions.
2. the output (some of the fields from lesson table)are then need to be referred to several lookup tables.(a table for each field)
3. the lookup tables have three main fields, which are:
query-record-similarity.
query refers to the fields name .
query needs to be compared with record and the similarity of this two fields will be taken.
this happens to several lookup tables.
the similarity then will be used to other function-to calculate the similarity of the quey with records in database
WHAT SQL STATEMENT SHOULD I USE?
UNION, JOIN,?
i don't have any idea.
Could someone help me how to do this?
Many thanks for your help.