Sqlite raw query to fetch data

I have 6 tables with same fields item_name, price, day, month, year. I want to fetch all data from every table using where condition. Ex.select * from table1, table2, table3, table4, table5, table6 where day=? And to display it. I don't understand how to write query. Need help . Thank you.