Hi, I'm trying to select from 3 tables but I can't seem to get it right. Here is the code:
$query_Recordset1 = sprintf("SELECT * , image.user_id, image.name, page.user_id, page.urlcode FROM users JOIN mystuff.page JOIN mystuff.image ON page.user_id = image.user_id = users.user_id WHERE users.last_name = %s AND users.first_name = %s", GetSQLValueString($colname_Recordset1, "text"),GetSQLValueString($colname2_Recordset1, "text"),GetSQLValueString($colname3_Recordset1, "text"));
If I remove the page table it works perfect but when I add it in I have problems. Any thoughts?
Thanks!