Hi I am trying get a query to join 2 tables and a result on the information in both. At the moment I have the following
$query = "SELECT * FROM TABLE1, TABLE2 Where 'TABLE2.field1' LIKE '%TABLE1.field2%'";
The problem is TABLE2 has a field with names in but TABLE1.field2 has |name|name|name| and so on. |=TAB
So im struggling for the query to find a match in there somewhere.
Can anybody suggest anything please