thelinuxlink.net

Posted: **Thu Jun 17, 2010 9:57 am**

so I have written a join:

SELECT telegrams.*, telegramMeta.* FROM telegrams
	 JOIN telegrams ON telegrams.id = joinMeta.telegramID
	 JOIN telegramMeta on joinMeta.metaID = telegramMeta.id

from our conversation years ago, this should work. Well, it didn't... So I did a little looking and wrote:

Code: Select all

SELECT telegrams.*, telegramMeta.* FROM telegrams as T1, telegramMeta as T2
	 JOIN telegrams ON telegrams.id = joinMeta.telegramID
	 JOIN telegramMeta on joinMeta.metaID = telegramMeta.id

but it complains about joinMeta.telegramID not existing. So I wrote:

Code: Select all

SELECT telegrams.*, telegramMeta.* FROM telegrams as T1, telegramMeta as T2
	 JOIN T1 ON T1.id = joinMeta.telegramID
	 JOIN telegramMeta on joinMeta.metaID = telegramMeta.id

and it complains about T1 not existing, which is fine because presumably the previous SQL statement liked telegrams, so I just returned to that statement. Any idea as to why it doesn't like joinMeta.telegramID?

U R still my hero, btw.

Posted: **Thu Jun 17, 2010 10:27 am**

ignore me, I'm stupid:

Code: Select all

SELECT telegrams . * , telegramMeta . * 
FROM  `telegramMeta` 
JOIN  `joinMeta` ON  `telegramMeta`.`id` =  `joinMeta`.`metaID` 
JOIN  `telegrams` ON  `joinMeta`.`telegramID` =  `telegrams`.`id`

and I don't need a join, necessarily. But I think I might have made things harder than they need to be.

thelinuxlink.net

Oh Great Dann (mySQL question)

Oh Great Dann (mySQL question)

Re: Oh Great Dann (mySQL question)