RE: Joins with priority

2001-11-14 Thread Roger Baklund
* 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

Joins with priority

2001-11-14 Thread Christopher Book
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

Joins with priority

2001-11-13 Thread Roger Baklund
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