How to get values that are in another table?

Y

yefenat2020-10-06 10:26:38

Laravel

yefenat, 2020-10-06 10:26:38

I have 2 tables:

1. systems -> id, name
2. keys -> id, system_id

And such a question, how to get records from the table: systems, if id is in the table: keys -> system_id, and also: name in the systems table is not equal to: test1 and test2.

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

E

Eugene2020-05-08 10:55:29

Laravel 7 behind NGINX with SSL can't load assets? 0Reply

D

Dasha2015-11-08 14:53:39

How to make a timer for each entry in the database? 5Reply

V

Vlad Osadchyi2020-05-09 15:45:33

How to properly update the application when the queue handler is running? 3Reply

R

Roman Sarvarov2021-07-13 17:06:29

How to check the action in the policy on an unlogged user? 3Reply

M

mrSeller2018-03-19 21:03:36

Sessions are not deleted or reassigned in laravel - what's the matter? 1Reply

Didn't find what you were looking for?

Ask your question