Part match for query

[hnorgaar]

hi

I have 2 tables with texts and they only partly match, so I will like to do

Have from table1 field1 "2 red tables xxxxxxxx" to match in table 2 field1 "red" and give me output from table 2 field2 Translate "Rød"

I have attached my small database with try which doesnt work


Thx for any input

[CJ_London]

perhaps just remove the join between the two tables.

if you just want where red like "*red*" then you need to either have some means of separating out the 'red' from the full text (using instr/left/mid type functions), or maintain a separate keywords table and compare via that table

[hnorgaar]

I dont want to separate, I want the field which correspond with translated text, and I have 2 tables and try to match/compare between them. The real database I have is a bit more complicated and the provided base is just for reference

[CJ_London]

1. suggest you try my suggested solution (remove the link)
2. if this does not meet your needs then based on your limited example in the db what do you expect to match?
3. you say the real situation is more complicated so chances as any solution based on your simple data won't meet your needs

If you want a proper solution, provide proper data with the result required. Don't waste everyone's time creating solutions that don't meet you needs

[hnorgaar]

Ok, thx for your help