Snooker - Player Statistics
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Cubbington_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Frames_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Frames_3rd WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Frames_4th WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Harbury_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Home_Guard_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Kenilworth_Cons_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Kenilworth_SSFC WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Lillington_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Lillington_2nd WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Nelson_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Nelson_2nd WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Priors_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
UNION
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Warwick_Cons_1st WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
ORDER BY Perc DESC , PtsDiff DESC , Won DESC , F DESC , PlayerName: Table 'db233443736.Cubbington_1st' doesn't exist 
