locked
how to display a joined tables data in page template? RRS feed

  • Question

  • User1174340047 posted
    how to display a joined tables data in page template? hi,all. by default, dynamic data displays data from only one table in one page template, for example, data from Orders and [Order Details] tables are displayed in two seperate pages. Now i want to display data from both Orders and [Order Details] tables in single page. For example, i want to display data from the following sql result in the List.aspx template: select O.OrderID, O.OrderDate,D.UnitPrice from Orders O, [Order Details] D where O.OrderID = D.OrderID How can i achieve that? Thank you in advance.
    Friday, September 19, 2008 4:35 AM

All replies