Shell Programming and Scripting

Hi All,
Please help me writing the below script.

I have two sql queries.

1. Select count(1),Client_id from TABLE_A group by Client_id;
2. Select count(1),Client_id from TABLE_B group by Client_id;

I need the output of above two sql queries in a single file. The output 2nd query should be appended to the output of first query.

Thanks.

Search the forums. You find several examples of how to do it.

Alternatively, you can do that in the SQL script itself. Since you haven't mentioned what database you are using, I'd suggest you to check the SQL documentation of your database.

tyler_durden

Uh. What's wrong with these people - minimal information provided, maximum outcome required...

Given that this is an Oracle script, AND given that these queries are in different scripts:
Or use similar method in yourveryowndatabasesoftware.

pen

If your working on Unix/Linux you can use HERE Documents in a shell script, like this:

#!/bin/bash

( sqlclient user@password << EOF

Select count(1),Client_id from TABLE_A group by Client_id;
Select count(1),Client_id from TABLE_B group by Client_id;

disconn
EOF
) > query_op_file

If both the queries don't give desired output into the file, then get the output individually and then:

cat 2nd_query_op_file >> 1st_query_op_file (appends output of 2nd query to the first one)