as per your input above in if there is a data in table 2 if table 1 and table 3 is empty do i need to make it full join?...

nope i did not correct them, i just put what you have given me, as you know i am real noob in SQL, what is the correct alias btw? and...

the system got stuck and i waited for around 5 mins then tried it again same thing.

Dan.Humphries (4/20/2011)

---

This should do the trick.

SELECT

p.employee,

p.first_name,

p.last_name,

d.description,

b.expired_date,

u1.description,

u2.description,

u3.description

FROM

person p

left join badge b on b.person_id = p.id

left join department d on d.id = p.department

left join person_user u1...

thank you very much, i will try it out on the site, hopefully it works.

I will try to explain it in the best i can as i am not on the site, basically the person_user are user field ex. user1 user2 user3 and u.description...

My query is giving this output:

SELECT

p.employee,

p.first_name,

p.last_name,

d.description,

b.expired_date,

u.description

FROM person p

left join badge b on b.person_id = p.id

left join department d on d.id = p.department

left join person_user u...