Returning Values from Subquery 1

[trbyrne]

Using Perv. SQL v8.6, I am trying to pull values from one table based on the query results from another table. I have tried the two SQL statements below but received errors (indicated for each statement).

SELECT * FROM "CUSTREL" where customernum in [select customernum from customer where accounttype='GLB']
>>>ERROR - invalid row count in subquery

SELECT * FROM "CUSTREL" where customernum in [select customernum from customer where accounttype='GLB']
>>>ERROR - where customernum in << ??? >>[select....

 

[mirtheil]

I'm not sure of V8 supports subqueries but you you might try:
SELECT * FROM "CUSTREL" where customernum in (select c.customernum from customer c where c.accounttype='GLB')

I used parenthesis instead of brackets and also added the table designation on the subquery.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[trbyrne]

That did it! Thanks again Mirtheil for your valuable help!

 

[mirtheil]

No problem. Thanks for the star.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com