Re: Default or existing value if JOIN ON clause fail?

anagorn wrote: I am trying to get "default" value for every ID of JOIN if ON clause were unsucessfull. In my example, I am trying to get "english" rows, but if they are not available, I would like to get default - "estonian". I have two tables ie. table1: id 1 2 3 table2: id - lang - desc 1 - eng

Default or existing value if JOIN ON clause fail?

I am trying to get "default" value for every ID of JOIN if ON clause were unsucessfull. In my example, I am trying to get "english" rows, but if they are not available, I would like to get default - "estonian". I have two tables ie. table1: id 1 2 3 table2: id - lang - desc 1 - english - EN_A