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?
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.