Sheldon Livingston
asked on
Select within select
Select
name, address, sales
from
data
where
sales > 100k
Returns records where sales are greater than 100k.
What if I want to see everyone but only the sales if they are more than 100k:
Select
name, address, sales if sales > 100k
from
data
Possible with Pervasive?
name, address, sales
from
data
where
sales > 100k
Returns records where sales are greater than 100k.
What if I want to see everyone but only the sales if they are more than 100k:
Select
name, address, sales if sales > 100k
from
data
Possible with Pervasive?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER