MySQL Forums
Forum List  »  Newbie

Select over 2 tables
Posted by: Thorsten Senkel
Date: March 06, 2020 08:12AM

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

Options: ReplyQuote


Subject
Written By
Posted
Select over 2 tables
March 06, 2020 08:12AM
March 06, 2020 10:48AM


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.