如何从MySQL中的多个表循环数据？

Question

I have these tables with the following columns:

Article

1.1. title
1.2. text
1.3. sortnr

Congress

2.1. title
2.2. text
2.3. sortnr

And, obviously, others, but these are the ones that are the same. And what I'd like to do is write a query where I can then loop through these fields as if they were from one table.

What it looks like:

SELECT * FROM article, congress ORDER BY sortDate DESC LIMIT 3

but with that I can't use fields like title and so on because during the loop, all the, for example, title fields are being turned in to the ones from congress table.

Is there a way to mix the two tables and treat them like they were from one table considering that they aren't joined in any way?

Answer 1

Try this:

SELECT *, 'article' as tblnm FROM article
UNION
SELECT *, 'konferansenentry' as tblnm FROM konferansenentry 
ORDER BY sortDate DESC 
LIMIT 3

It will only work if both table have same field other wise you have to select individual one by one.