I have a DB structure which has numerous falt tables. I am trying to run a query to show all best from various tables.
The query on one table works fine, but I am unable to run a query that will show all perfrimances from the others(4 in total)
This works, but on just one table. Union Query fails:
$query = "SELECT DISTINCT fname, sname, club FROM out2006 WHERE event = '$ap' ORDER BY perf, mid, perf2 DESC";
All I want to do is pull same from 4 tables- same field names
Charles
