[RESOLVED] Join Query Problem

sascha

Hello ,

i have a problem with a query...

2 tables like this

i need an array wich is order by row with all Names and the content and the trContent but the big problem is that resName is not unique it is identifiable or other said the relation is build over over the contentpart
so the combination of name and contentpart gives the relation from resContent to trContent

i need resContent and trContent side by side sorted by relation over resName and resContentPart

i need the resName, resContent, restrContent, resContentPart and a few other unimportant colums in one array

i tried a query like this = 'SELECT to.resPartID, to.resName, to.resourceFileRow, to.resContent, to.resContentPart AS resPart, tt.trContent, tt.resContentPart FROM TableOne to LEFT OUTER JOIN TableTwo tt ON to.resName=tt.resName AND tt.langID=? WHERE to.resFileID=? AND to.resContentType="TEXT" ORDER BY to.row',$_SESSION['languageID'] ,$resFile['resFileID'] ;

wich looked at first good but later then when the trContent is filled i get multiple outcomes for resname and rescontent,restrContent ;(

i hope somebody can undertand/solve this ....

thanks a lot for your time

tomhath

Isn't it enough to add this?

SELECT ...
FROM TableOne to
LEFT OUTER JOIN TableTwo tt
ON to.resName=tt.resName AND tt.langID=?

AND to.rescontentPart=tt.rescontentPart

WHERE...

sascha

yeah ,
that´s it

thanks a lot ...