0 votes
Hi,

I'm far from being a SQL expert, so i'm going to try to explain my issue as well as possible :

I have a list of IDs (in a csv file for example) and i want to get different information about them that are stored in many different oracle tables.

So everytime I call a table, I want to be able to do something like that :

SELECT RelevantInfo, ID

FROM mytable

WHERE ID in "mylistofIDs"

 

How can I do that ?

Thank you
asked by

1 Answer

0 votes
Hi,

Yes, you can do it if you import your list of IDs in your db:

SELECT RelevantInfo, ID

FROM mytable

WHERE ID in (select ID from listOfId)

 

Here's some examples: http://www.dofactory.com/sql/where-in
answered by
942 questions
977 answers
986 comments
2,072 users

©Dataiku 2012-2018 - Privacy Policy