Hi all,

i want to query our database with the qptool6.1-Prog.
My script looks like:
$BSE/bin/qptool6.1 -c 000 -o /tmp/query.out -q "select a.user,b.date,time from ttadv997 a,ttadv998 b where a.applid = b.applid" > /tmp/logquery.out

And I´m getting the following error message:

[2] Unknown column 'a.user'
[2] Unknown column 'b.date'
[2] Unknown column 'time'
[2] Unknown column 'time'
[0] Found 4 errors during scanning/parsing .. Stopped.

so where is my fault?

We are using triton3.1,Oracle 7.3.4.4 , Hpux10.20

Thanks.

Greetings
HM

Why don't you make it easier:
select ttadv997.user, ttadv998.date,ttadv998.time from ttadv997 ,ttadv998 where ttadv998.applid = ttadv997.applid"

This works with me

Hi,

the simple things.....

Thanks for your help.

Greetings HM