Blog Post
danszczepanski
3 months agoNew Contributor III
Hello!
So, I have made it through until where we add the two tables to the new DataSet, but for some reason, only regDt data is populating "dsn".
Dim dsn As New DataSet("SKUSales")
dsn.Tables.Add(regDt)
dsn.Tables.Add(blendDt)
dsn.Relations.Add("SKURelation", _
dsn.Tables(0).Columns("SKU"), _
dsn.Tables(1).Columns("SKU"), _
False)
Return dsn
I tested the query for each table, and those queries return expected results.
I believe the error is where we add in the "SKU" columns but am unsure how to fix. SKU is a like column in both tables.