you are going to want to use a join. select * from table1 left join table2 on id.table1 = id.table2
A Anonymous Guest Aug 8, 2004 #1 you are going to want to use a join. Code: select * from table1 left join table2 on id.table1 = id.table2
you are going to want to use a join. Code: select * from table1 left join table2 on id.table1 = id.table2
A Anonymous Guest Aug 16, 2004 #2 Code: $query = "SELECT * FROM table1 LEFT JOIN table2 ON table1.field1 = table2.field2; You can try this and then experiment on new WHERE statements, you can even join two or more tables.[/code]
Code: $query = "SELECT * FROM table1 LEFT JOIN table2 ON table1.field1 = table2.field2; You can try this and then experiment on new WHERE statements, you can even join two or more tables.[/code]
