I have 2 tables both are totally unrelated, but I need to query both to extract data. For example, I have a table called news1 and another called news2. I want to query everything from news1 within a certain date and everything from news2 within a certain date and have the results outputted. I am getting problems where it concatenates the results of news2 to news1.
So basically data in news1 is something like:
And data in news2 is something like
I would like the output to be printed as 2 different rows
Not as 1 row : “hi there | not here”
Any clues? Thanks.