DSXchange

2 new fields are added to oracle table.to populate this I need to execute a sql which willbe using 2 tables and if itsatisfies the criteria of the sqli i need to populate the field with yes. for the 2nd field i have a different sql which i need to execute and then populate that with yes.
can you please let me know how to do this
In the query caluse should i give the names of all the tables involved in the query.

You have not told us which database you are using, but the obvious mechanism seems to be an UPDATE statement containing two nested SELECT statements each of which includes a CASE construct to make the Yes/No decision.

In DataStage, of course, you could perform lookups to make the decision.

But you seen to have the notion of using SQL fixed in your mind for some reason.

itis oracle database.