Filtering data using multiple table

Question

I am trying to do a filter on a data set using another table to define the filter query. In the first table I have the filter strings, for example: AP, EX and SU. In a second table I have the data set that I want to filter. Apple, Applet, Abbot, Acronym, event, example, solution, sum. When I do a select I need to return only the results that begin with any value in the first table. So the results will be Apple, Applet, Example and Sum. The best that comes to my mind is the query below, which I did try and gave errors.

SELECT * FROM tblData WHERE Word LIKE (SELECT filter + '%' FROM tblFilter)

juergen d · Accepted Answer · 2016-04-10 09:01:19Z

2

SELECT d.* 
FROM tblData d
JOIN tblFilter f on d.word like (f.filter + '%')

answered Apr 10, 2016 at 9:01

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

5tar-Kaster Over a year ago

Elegant and straight forward, this worked 100% thanks

Collectives™ on Stack Overflow

Filtering data using multiple table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related