0

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);
1
Contributor
1
Reply
2
Views
4 Years
Discussion Span
Last Post by mpc123
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.