P
peterg2000qc
Guest
I need to create a new dataset from 3 tables and 2 SQL sources 1 MSSQL and the other MySQL.
file 1 contains 30 fields with the index on a network number say 'NetworkID'. (3000 records) file 2 contains 8 fields with the index also on a Network number say 'NWK_ID'. (1,900,000 records) file 3 contains 3 fields with index on field 'code' (50 records)
In the dataset designer I placed relationships between file 1 'Network' and file 2 'NWK_ID'. and another relationship between file 3 'code' and file 2 'activity'
The reason for the first relationship is to only include records from file 2 that have a record in file 1.
The 2nd relationship is to show the code type based on the activity code!
I just can't figure out how to get these combinded into a query! This is code being ported over from an Access application!I have no problems doing it there!
SELECT MSSQLDB.NetworkID, MySQLDBA.activity, MySQLDBA.cap_plan, MySQLDBA.cap_act, MySQLDBA.cap_var, MySQLDBA.exp_plan, MySQLDBCode.typedef
FROM (MSSQLDB INNER JOIN MySQLDBA ON MSSQLDB.NETWORKID = MySQLDBA.NWK_ID) INNER JOIN MySQLDBCode ON MySQLDB.activity = MySQLDBCode.code
So now I have a dataset1.xsd file via the dataset designer with 3 tableadapters with relations applied but can't seem to figure out how to build a new table with parts of the 3 adapters!
In case you haven't noticed I'm new to vb.net! I'm using VS2015 as VS2019 has too many bugs!
Thanks
Continue reading...
file 1 contains 30 fields with the index on a network number say 'NetworkID'. (3000 records) file 2 contains 8 fields with the index also on a Network number say 'NWK_ID'. (1,900,000 records) file 3 contains 3 fields with index on field 'code' (50 records)
In the dataset designer I placed relationships between file 1 'Network' and file 2 'NWK_ID'. and another relationship between file 3 'code' and file 2 'activity'
The reason for the first relationship is to only include records from file 2 that have a record in file 1.
The 2nd relationship is to show the code type based on the activity code!
I just can't figure out how to get these combinded into a query! This is code being ported over from an Access application!I have no problems doing it there!
SELECT MSSQLDB.NetworkID, MySQLDBA.activity, MySQLDBA.cap_plan, MySQLDBA.cap_act, MySQLDBA.cap_var, MySQLDBA.exp_plan, MySQLDBCode.typedef
FROM (MSSQLDB INNER JOIN MySQLDBA ON MSSQLDB.NETWORKID = MySQLDBA.NWK_ID) INNER JOIN MySQLDBCode ON MySQLDB.activity = MySQLDBCode.code
So now I have a dataset1.xsd file via the dataset designer with 3 tableadapters with relations applied but can't seem to figure out how to build a new table with parts of the 3 adapters!
In case you haven't noticed I'm new to vb.net! I'm using VS2015 as VS2019 has too many bugs!
Thanks
Continue reading...