Hello - First off, I want to thank everyone on the forum.
I am pretty new to Pervasive and have a syntax question. I do a lot of reporting, where I would like to utilize nested queries. I came from using Oracle and SQL Server and never had any troubles doing this in either. Below, I have included the code that I would write if I were in Oracle, since it's probably easier to see the code than hear me trying to explain myself :-)
SELECT A.job, A.sum_a, B.b
(select job, sum(a) sum_a from table_A) A,
(select job, b from table_B) B
WHERE A.job = B.job (+)*
*implies Left Outer Join in Oracle
This is maybe not the most practical example, but I think it does show what I am attempting to do very well. Any expertise would be much appreciated.