Snooker - Player Statistics
SELECT *, (Pld-Won) AS L, (F-A) AS PtsDiff, (Won/Pld*100) AS Perc FROM Bishops_Tachbrook 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 Cubbington_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 Frames_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 Harbury_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 Home_Guard_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 Kenilworth_Cons_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 Leamington_Liberals 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_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 Lillington_Bowls 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_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 Oakhouse 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_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_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 Warwick_Cons_2nd WHERE Pld > 0 AND PlayerName NOT IN ('No Player')
ORDER BY Perc DESC , PtsDiff DESC , Won DESC , F DESC , PlayerName: Table 'db233443736.Bishops_Tachbrook' doesn't exist 
