Select from 2 tables and reselect if not exists

[FrEaKmAn]

Hello

I have 2 tables,

CREATE TABLE `events` (
  `id` int(11) NOT NULL auto_increment,
  `type` int(1) NOT NULL,
  `typeid` int(5) NOT NULL,
  `dt` datetime NOT NULL,
  `locationid` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
CREATE TABLE `events_language` (
  `id` int(5) NOT NULL auto_increment,
  `eventid` int(5) NOT NULL,
  `title` varchar(255) collate utf8_unicode_ci NOT NULL,
  `text` text collate utf8_unicode_ci NOT NULL,
  `languageid` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 

Now I select from this 2 tables and join them on events.id and events_language.eventid. I also include languageid as I'm making multilanguage site. Now the problem is that users will insert this data and I'll have around 5-6 languages and nobody will insert all fields. So my solution was to load all events and then if there is no input in events_language with specific languageid, then load some other language...

is this possible?

[r035198x]

Try using a CASE.