I'm trying to create a report. I've got the forms put together and created an SQL query that works. However, when I try to run the report, I get the following:
SELECT ``.* FROM `` WHERE = '150d680184d5bf'
The SQL query looks like this:
$s = "CREATE TABLE #dataTable# SELECT * ";
$s .= "FROM result ";
$s .= "LEFT JOIN team ON res_team_id = team_id ";
$s .= "LEFT JOIN wl ON res_winloss_wl_id = wl_id ";
$s .= "LEFT JOIN location ON res_homeVist = loc_id ";
$s .= "ORDER BY res_date ASC , res_gameNumber ASC ";
nuRunQuery ($s);
Any help would be great. (Also, if there is a more indepth tutorial on the report, I'd love that.)