Hi I am trying to join tables and fields and one of the tables had fields like field.field . So when I try to do a join it does not know the table field name as you end up with something like Table1.field.Name
How do I get round this please
$result = mysql_query("SELECT DISTINCT `Table1.field.Name`, `Table1.field.Name1`, `Table1.field.Name2`, `Table1.field.Name3`, `Table2.fieldName1`, `Table2.fieldName1` FROM Table1, Table2 WHERE `Table1.field.Name` = '$txt1' and `Table1.field.Name1` = '$txt2' and Table1.field.name2 = table2.fieldname1") or trigger_error(mysql_error().$sql);