I have two queries, and I want to join the first query with the second in SQL, here are my queries,
FIRST QUERY
OleDbCommand Query1 = new OleDbCommand();
Query.CommandText = "SELECT [Mastertable].ID " +
"FROM [Mastertable] INNER JOIN [relationship] ON [Mastertable].ID = [relationship].SW1_ID " +
"WHERE ([Mastertable].[PN]= @PN AND [Mastertable].[Ver]=@Ver) " +
"GROUP BY [Mastertable].[ID]";
DataSet ResultSet = RunQuery(Query1);
The above query basic return the ID where PN = PN input and Ver = Version input.( I put the result in a Dataset
I want to join the ID column from query1 to Mastertable. ID again
the 2nd query,
OleDbCommand Query2 = new OleDbCommand();
Query2.CommandText = "SELECT [SW Mastertable].SW_PN, [SW Mastertable].[SW_Ver], [SW relationship].[SW2_Category], [SW Mastertable].[Component_Name] " +
"F ...
Go to the complete details ...