mysql join clause equivalent where clauses and vice verse

Question

I want to replace my

SELECT *  FROM TABLE 1, TABLE 2
WHERE tbl1.aaa = tbl2.bbb

to replace something with join clause, and similar other replacements vice verse, is there a quick reference on this?

Nilesh Thakkar · Answer 1 · 2015-04-09T10:07:07.537

0

Its as simple as below.

SELECT *  FROM tbl1 INNER JOIN tbl2 ON tbl1.aaa = tbl2.bbb

edited Apr 09 '15 at 10:07

answered Apr 09 '15 at 10:05

Nilesh Thakkar

@PhillipD, it must be ON missing, since USING requires same column names. – jarlh Apr 09 '15 at 10:08
I know I just need a big reference on specifically replacing where statements to join statements. – user3410843 Apr 09 '15 at 10:10
This may help you to answer why you should use `JOIN` over `Where` http://stackoverflow.com/questions/2241991/in-mysql-queries-why-use-join-instead-of-where – Nilesh Thakkar Apr 09 '15 at 10:12

score 0 · Answer 2 · edited Apr 09 '15 at 11:53

0

Try this script:

SELECT *  
FROM TABLE 1 as tbl1 
JOIN TABLE 2 as tbl2
 on tbl1.aaa = tbl2.bbb

or

edited Apr 09 '15 at 11:53

whytheq

answered Apr 09 '15 at 10:11

"link-only answers" should be comments, not answers. – Gordon Linoff Apr 09 '15 at 12:01

2 Answers2