In-Line Select Sub-Query in Access...

[MikeDamone]

Does anyone know who to do an in-line select query in Access. In oracle I know hoe to do this but not in Access. For example in Oracle I can do this. Thanks for any help!

select
last_name,
first_name,
(select job from emp_jobs where id = person.id) job,
address
From
Person
where
last_name = 'Smith'

 

[PHV]

Why do you think it should be different in access ?

 

[PHV]

OK, access insists on AS:
(select job from emp_jobs where id = person.id) [!]AS[/!] job

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886