RE: Can a JOIN statement do this?

2009-01-01 Thread Martin Gainty
content contained within this transmission. Date: Thu, 1 Jan 2009 11:28:51 +0800 From: mik...@qualityadvantages.com To: mysql@lists.mysql.com Subject: Can a JOIN statement do this? Hello mysql and Happy New Year, I am working with a Forum database. It contains a forums table, a posts

Can a JOIN statement do this?

2008-12-31 Thread mikesz
Hello mysql and Happy New Year, I am working with a Forum database. It contains a forums table, a posts table and a threads table. Some of the posts contain flash objects that I can find using a query like this one: SELECT `pagetext`, `postid` FROM `post` WHERE `pagetext` LIKE