G
Guest
I have an orders table. Each record in the orders table contains a customer id.
I have a customer table. The primary key of each record in the customer
table is the customer id.
After getting a subset from the orders table, I need to take the customer
ids in the orders table subset, and list each record in the customer table
that has a matching customer id.
If I were in t-sql, this would be an easy inner join. In this case, I get
both complete tables in memory, and can only show the subset tables as
DataViews (or something like a DataView). I can't toss the original tables as
the user can request different views.
Any thoughts on creating a DataView in an inner join sort of way?
Thanks,
I have a customer table. The primary key of each record in the customer
table is the customer id.
After getting a subset from the orders table, I need to take the customer
ids in the orders table subset, and list each record in the customer table
that has a matching customer id.
If I were in t-sql, this would be an easy inner join. In this case, I get
both complete tables in memory, and can only show the subset tables as
DataViews (or something like a DataView). I can't toss the original tables as
the user can request different views.
Any thoughts on creating a DataView in an inner join sort of way?
Thanks,