Select over 2 tables
Hello all,
i want to create a select.
table1:
table_id, KD_ID, Name, text1, text2, creator
table2
KD_ID, name2, name2, land
i want to select for example:
select *
from table1
where creator = 'HelloWorld'
(and then check if the KD_ID of this result is the field in table2 land = 'ch'
in Table 1 are the list of jobs.
in table2 are the user
i want to select all jobs with special conditions from table1.
But only from land (table2) ch or de and so on...
does anybody can help?
kindly regards...
Thorsten
Subject
Written By
Posted
Select over 2 tables
March 06, 2020 08:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.