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);

Sorry found this issue, `` changes to ''

Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.