varsha waghmode

varsha waghmode

  • 2k
  • 62
  • 10k

collecting data in sigle datatable by selecting two sets of rows from same table

Sep 11 2012 3:51 AM
I want to select two different set of rows(same no of columns)from single table and  and i want to collect it in a single datatable .
First query is

"select * from TABLE1 where chapter_name='chapter1'";

and second query is

"select * from TABLE1 where chapter_name 'chapter2'";

now i want to collect result of these two queries into a single datatable.
please suggest an answer

Answers (6)