Add results from two queries and output as a separate table

Question

I have two queries that I have to fulfill, I can join them, but their resulting tables have the same structure.

For example, I have

select * from products where producttype=magazine select * from products where producttype = book 

I need to combine the result of these two queries and then output it as a single result. I have to do this in a stored procedure.

PS These are just the examples that I presented, I have a complex table structure. Most importantly, I can’t join them.

Answer 1

 select * from products where producttype=magazine union select * from products where producttype = book 

Answer 2

I think there are varchar values ​​in the log and book, not the columns in the table.

 select * from products where producttype in ('magazine', 'book'); 

Answer 3

Or just one request ...

 select * from products where producttype = magazine or producttype = book