I have googled and also searched stack overflow but I am not able to find a solution for this.
I have an access database in which I have a table A and table B. Table A has a list of 200 website URLs. Table B has one coloumn ID and another criteria.
I want to create a query to filter websites list which does not have values or characters from table b.
I have these values in table B that I want to be filtered out or not shown in my URL Select Query
.org
.gov
.du
.pk
.dk
I would keep on adding more criterias into this so criteria table so adding new criteria into table B should not disturb our filtering.
I thought this is easy but really I don't seem to find a solution to this. Any help is highly appreciated. Below is what I have tried but in vain and it says atmost you can atmost one criteria row in sub query
SELECT tableA.WEB_ADDRESS
FROM tableA
WHERE ((([tableA].[wEB_ADDRESS] Not Like '*'+(SELECT * FROM tableB)+'*')=True));
Best regards,
Zeeshan