search between two tables
<p>I want to search between 2 tables for matching strings.</p>

<p>For eg. I have a Members table (<code>tblprofile.area_of_specialization</code>) which contains comma delimited strings like Engineering, Plumber, Technician, etc…)</p>

<p>I also have another table (<code>tbljobs.area_of_specialization</code>) which contains comma delimited strings like Engineering, Electrician, Painting, etc…)</p>

<p>Please, how do I search between these tables and match table jobs with those whose their profile qualify for the job?</p>

<p>Thanks</p>

<p>I am not sure this violates normalization guidelines. I am looking at having something like <code>SELECT *** FROM ** WHERE tblprofile.area_of_specialization LIKE tbljobs.jobcriteria.</code>
---this works just that the match is not 100% because of the constraints in using LIKE %'...'%</p>
