ScrewLooseSalad Posted April 3, 2013 Share Posted April 3, 2013 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 Quote Link to comment https://forums.phpfreaks.com/topic/276484-select-from-multiple-tables-from-columns-the-same-name/ Share on other sites More sharing options...
Jessica Posted April 3, 2013 Share Posted April 3, 2013 Why do you have 8 tables with the exact same structure?? Try doing a UNION instead. Quote Link to comment https://forums.phpfreaks.com/topic/276484-select-from-multiple-tables-from-columns-the-same-name/#findComment-1422655 Share on other sites More sharing options...
ScrewLooseSalad Posted April 3, 2013 Author Share Posted April 3, 2013 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... Quote Link to comment https://forums.phpfreaks.com/topic/276484-select-from-multiple-tables-from-columns-the-same-name/#findComment-1422656 Share on other sites More sharing options...
Solution ScrewLooseSalad Posted April 3, 2013 Author Solution Share Posted April 3, 2013 Why do you have 8 tables with the exact same structure?? Try doing a UNION instead. Perfect! Thats just what I needed! Thankyou Quote Link to comment https://forums.phpfreaks.com/topic/276484-select-from-multiple-tables-from-columns-the-same-name/#findComment-1422657 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.