SELECT from multiple tables, from columns the same name

[ScrewLooseSalad]

  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

[Jessica]

Why do you have 8 tables with the exact same structure??

 

Try doing a UNION instead.

[ScrewLooseSalad]

Why do you have 8 tables with the exact same structure??

 

Try doing a UNION instead.

 

I know its daft

but I'm stuck with it for the time being

 

I'll read into UNION now...

[ScrewLooseSalad]

Why do you have 8 tables with the exact same structure??

 

Try doing a UNION instead.

 

Perfect! Thats just what I needed! Thankyou