Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Nested select?

  1. #1
    Join Date
    Mar 2008
    Posts
    3

    Default Nested select?

    such as:

    select A.a , B.b , ...
    from A , (select ... from ...) B
    where ...

    if i can using step lookup get "B" ,and other step looup get "A",
    next using stream lookup to filter "A" and "B"?

    yet, i can't get solution

    help me, thanks!

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Depending on your where clause you could use a merge join step. But usually these kinds of things are better done in the database if all data is in 1 database.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.