<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
I'm not certain what you are trying to do, but...<br>
<br>
Consider the SQL "UNION", "UNION ALL", "INTERSECT", or "INTERSECT
ALL" statements perhaps? They allow you to combine the results of
two queries into a single result set (as a single query.)<br>
<br>
Chander<br>
<br>
On 2/14/12 1:24 PM, Bob Pawley wrote:
<blockquote cite="mid:B8B7F192430A4712BC447E4529317630@BobPC"
type="cite">
<div dir="ltr">
<div style="FONT-FAMILY: 'Arial Narrow'; COLOR: #00002b;
FONT-SIZE: 12pt">
<div><font size="5">Is there a method of having two –sql
commands in one command prompt execution.</font></div>
<div> </div>
<div><font size="5">I have attempted </font></div>
<div> </div>
<div><font size="5">1. –sql “first statement ” –sql “second“</font></div>
<div> </div>
<div><font size="5">2. –sql “first; second“</font></div>
<div> </div>
<div><font size="5">3. sql “first “ “second“</font></div>
<div> </div>
<div><font size="5">4. –sql “first” –overwrite –skipfailures
-sql “second” (an attempt to separate the two).</font></div>
<div> </div>
<div><font size="5">Bob</font></div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/gdal-dev">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a></pre>
</blockquote>
<br>
<br>
</body>
</html>