varsha waghmode

varsha waghmode

  • NA
  • 62
  • 10.6k

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

Sep 11 2012 3:51 AM
hello...
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 .
e.g.
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)