How to use WHERE when combining two queries?

Question

There is a request:

SELECT t1.val, t2.val2 FROM dungeons,locations

How can I put a WHERE to select one from the first table and another from the second table. For example, I want to choose from the first

 WHERE rating > 100

and from the second

 WHERE money=0

Viktorov Viktorov 5.467 four 20 46 · Accepted Answer · 2016-12-30T17:15:19

 SELECT t1.val, t2.val2 FROM dungeons t1,locations t2 WHERE t1.rating > 100 and t2.money=0

Viktorov

5.467 four 20 46

It works, but for some reason only after the second browser update. What could be the reason? - Erepaha
@Erepaha you said nothing about the browser before - Matty
but now he said) - Erepaha
And for more information about the browser, please - Viktorov
I send this request in general, right after it I look through var_dump (), returns NULL, I update the page in the browser, everything works. But it doesn't suit me :( - Erepaha

|

1 answer 1