SQL join with complex case condition

here is a way to do this

select t3.eid,t1.text
  from t3
  join t2
    on t3.value between t2.min and t2.max
  join t1
    on t2.code=t1.code

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top