GoFuckYourself.com - Adult Webmaster Forum - View Single Post

donborno · 10-20-2012, 08:58 AM

SELECT banner.id, programs.name, banner.site
FROM banner
LEFT JOIN programs ON banner.program_id = programs.id
WHERE blah, blah blah, meh meh meh...

Probably it's an INNER JOIN unless you have banners which do not reference a program

10-20-2012, 08:58 AM
donborno Confirmed User Join Date: Jan 2007 Location: Vienna, Austria Posts: 374	SELECT banner.id, programs.name, banner.site FROM banner LEFT JOIN programs ON banner.program_id = programs.id WHERE blah, blah blah, meh meh meh... Probably it's an INNER JOIN unless you have banners which do not reference a program