I have 8 Tables, each contain the same 8 columns, I want to select all of these tables that have a value not equal to zero from one of these columns; the queries I've been able to jumble together from SQL I've found online output each of the tables three times; can anyone help me find the SQL query I need? Thanks.
Amongst other things I've tried:
SELECT tableC.column6, tableF.column6 FROM tableC, tableF WHERE tableC.column6!=0 OR tableF.column6!=0