Hello
I need to construct a fairly complicted query. I know I can do this by using a typed view, but I would like to know if I can do what I would like using typedlists. What I would like to is mimic a query that selects from another typed list. Lett me explain: In SQL Server I have saved a view. In another view I added a table and then added the saved view, then added a 1:m relation between the primary key and the corresponding field in one of the tables in the typed view. The SQL looks something like this:
SELECT dbo.Property_Bookings.PB_RefId, dbo.RSS_CustomerView.Customer_FirstName, dbo.RSS_CustomerView.Customer_LastName,
dbo.RSS_CustomerView.CustomerCountry
FROM dbo.Property_Bookings INNER JOIN
dbo.RSS_CustomerView ON dbo.Property_Bookings.CustomerId = dbo.RSS_CustomersView.CustomerId
The table is "Property_Bookings" and the view is "RSS_CustomerView". The view "RSS_CustomersView" has 2 related tables: "Customers" and "Countries"
So - here is my question: If I have a typed list called "PropertyBookings" and another typed list called "Customers" (this typed list has the same 2 entities mentioned above), is there a way to relate the two typed lists to created one recordset like the above SQL query would? I really don't like the idea of relying on views in our SQL server - I would rather do it in code..
TIA
Steve