* Roger Baklund
> >I have two tables, and I want to join them based on some priority rules:
>
* Christopher Book
> If you use UNIONS (in MySQL 4.0) then you can simply union your different
> cases together.
Thanks, but I need a solution for version 3.23.39.
Roger Baklund,
Mobiliant AS
If you use UNIONS (in MySQL 4.0) then you can simply union your different
cases together.
Chris
>I have two tables, and I want to join them based on some priority rules:
-
Before posting, please check:
http://www.mysql.com
Hi,
I have two tables, and I want to join them based on some priority rules:
If some special values exist in the joined subset,
join all of those values,
otherwise
join the first occurence of some other special value,
if that value also does not exist,
join the first occurence of a third v