A script I'm working on has a set of two database tables, both with identical rows; but the row content is different.
This script as-is already has about 2 joins on each query; would it be feasible to join these two tables or simply make separate pages for each?
I'm not sure if I'm using the terminology correctly, but in a nutshell; in phpmyadmin:
table1 & table2 have only id as the similar row; joins on (t1.id=t2.id)
table3 & table4 have identical structure to table1 & table2, but there is no way to join like t1 & t2, because the id row only matches like so:
So, is it feasible to have the data from these tables in the same query, or better to have separate pages for t1/t2 & t3/t4?