SQL Join Not Returnig Desired Results -


i'm having little trouble getting sql query working give me desired results. have 3 tables. sql query should return records employee name, along corresponding department name, , division should exist. if not, should still display employee null division. here link sql fiddle...

http://sqlfiddle.com/#!3/76fbb/1/0

use left outer join instead of right outer join


Comments