Just for fun I tried…
SELECT title1, content1
SELECT title, content
and it worked fine. So, no need to qualify your table names with the news1. etc. I didn’t try, but I’m wondering if I wouldn’t have changed the field names, then put a where clause on, I’ll bet I’d have to qualify the names.
And, apparently, whatever order the columns are in first are what the field name in the result set is.
When I first started playing with SQL it was in Microsoft Access so I like to see what is the same and what is different as I use PHP/MySQL.
Also, you’re probably aware of this, but in a long query you could also do this:
SELECT title T1, content C1
SELECT title T2, content C2
to shorten news1.title="blah"
to shorten and make unique names.