can some one help me to write a query that will join two table into one.I tried the following but i get error "No value given for one or more required parameters."\[code\]Dim CmdStr As String = "SELECT col1, col2 FROM table1 UNION SELECT col1,col2 FROM table2"\[/code\]
