Using MySQL with innerjoin on repeater

[keiwc]

i am trying to inner join my file table with my rate tableusing this statement\[code\]SELECT F.FileID , F.Filename , R.FileRate FROM File F INNER JOIN rate R ON F.FileID = R.FileID WHERE Filename LIKE '%" + FileName + "%'";\[/code\]i am displaying the data using \[code\]<%# DataBinder.Eval(Container.DataItem, "Filename")%>\[/code\]but when i tried displaying \[code\]<%# DataBinder.Eval(Container.DataItem, "FileRate")%>\[/code\]it didnt work i have search and tried various ways like display it using \[code\]<%# DataBinder.Eval(Container.DataItem, "R.FileRate")%>\[/code\] also didn't workedeven tried renaming the FileRate by doing\[code\]SELECT F.FileID , F.Filename , R.FileRate AS Rate FROM File F INNER JOIN rate R ON F.FileID = R.FileID WHERE Filename LIKE '%" + FileName + "%'";\[/code\]then displaying using \[code\]<%# DataBinder.Eval(Container.DataItem, "Rate")%>\[/code\]thanks for the help in advance