I am having an issue with a table join query whhich later I will echo results into a table.
I have 2 x tables and Table1field1 has a number say 555 but table2field1 which I need to join to has 555 342 642 313 etc etc
This is what I have but it does not join.
SELECT * FROM Table1, Table2 Where `Table1.field2` = 'blar' and `Table1.field3` = 'blarblar' and 'table1.field1' LIKE "'%table2.field1%'" LIMIT 1
Hope someone can help with this