accessman2
Registered User.
- Local time
- Today, 02:43
- Joined
- Sep 15, 2005
- Messages
- 335
Hi,
I am using VB2005 Express.
I want to create the DataTable to store the temporary data (select * from table1 where [score]>90), the table variable name is tmp (dim tmp as New DataTable)
And then, I want to use this table to match up another table Using Inner Join/Left Join/Right Join
(select [tmp].* from [tmp] Inner Join table2 On [tmp].[Subject] = table2.[Subject])...
... there are many tables need to be compared...
In VB2005 Express, can I use DataTable to do that?
Because if everytime I do it in backend, it will take much time, I want to make it in VB2005, make virtual table/temp table, it makes faster.
Additionally, can we make temp query in VB2005?
Please let me know.
I am using VB2005 Express.
I want to create the DataTable to store the temporary data (select * from table1 where [score]>90), the table variable name is tmp (dim tmp as New DataTable)
And then, I want to use this table to match up another table Using Inner Join/Left Join/Right Join
(select [tmp].* from [tmp] Inner Join table2 On [tmp].[Subject] = table2.[Subject])...
... there are many tables need to be compared...
In VB2005 Express, can I use DataTable to do that?
Because if everytime I do it in backend, it will take much time, I want to make it in VB2005, make virtual table/temp table, it makes faster.
Additionally, can we make temp query in VB2005?
Please let me know.