How to copy multiple lines from a file to another using AWK?

Shell Programming and Scripting
1

Hi,

I have a abc.txt file.

In this file there is a SQL query which Iwant to copy and print it on another file.The query (for eg) is written like this:

SELECT field1,
field2,
field3
from table1,table2
where <conditions>
END

I want to copy this query to another file using AWK.Its very urgent .Can someone help me in this.

Thanks in advance.
JS

2 
awk '/SELECT/,/END/{print}' abc.txt > newfile
3

Thanku so much its working perfectly !!

4

What If i dont want to print the first and the last line but everthing else?
For eg : I dont want to print the SELECT and Last line, END but have to print all lines in between these two?