subselect query

[#1]

Hi,

Can we write subselect query in Qlikview? the example is below.

select name,(select jobName from usersjob where usersjob.userid=users.id) as JobName from users

Thanks,

[Gysbert_Wassenaar]

If you use an sql select statement then that is send to the database as is. Qlikview doesn't process it, the dbms it is send to does. So you can do whatever you want in sql as long as your dbms supports it.

The load statement can't do 'subselects'. The usual way is to use the exists function in a where clause or use the keep function. Here's a discussion with an example of both.

[#3]

Thanks for answer but actually we will get those records from qvd file and those tables are not in a same database.  I tried to ask basic question for it.