onuda denedim . o zamanda name alani birden cok dondugu icin kargasa oluyor
bkz:
http://img22.imageshack.us/img22/7158/adszts7.png
Cominication bir kere cikmasi lazımken birden cok kere yaziliyor.
sql sorgum
SELECT agendaitems.name, workitem, meetings.date, meetings.time, meetings.place, itemdetails.notes FROM items
inner join itemdetails ON items.id = itemdetails.itemid
inner join agendaitems on items.agendaitemid = agendaitems.id
inner join meetings on itemdetails.meetingid = meetings.id
where meetingprojectid = 0 and meetingtypeid = 4 order by agendaitems.name, workitem