How do I call a batch file from within another batch file?

Unless you batch file exists in one of your PATH variables, you need to provide to full path to the file.

While calling a batch file from a file by using the call statement in the following way
call bat1.bat
call bat2.bat

But it gives an error like "bat2.bat" is not an interanl or external command or program or batch file.
There is no path problem

i want to know how to execute a file(which has a sql command) from query analyzer
main problem is
1 a batch file which has following command
(osql -S server -U sa -P sa < C:\\SCRIPT.SQL > C:\\Result.txt)

2 script.sql has the name of files
CreateTable.sql
CreateProcedure.sql

3 above given 2 files have script to create the tables & procedure respectivly


so please tell me how i can do it

thanking tou