Selecting data from two different tables without using joins

Question

I've got table1 and table2 and need to get data out from each of them.

Table1

"id"    "name"      "description"
"1"     "Windows"   "Microsoft Windows 8"

Table2

"id" "type" "name"              "description"
"1"  "22"   "Microsoft Windows" "Microsoft Windows 8 Home"
"2"  "2"    "Not an Edit"       "Not an Edit"

I do the select like this

select table1.name, table1.description, 
table2.name, table2.description 
from table1,table2 
where table2.id=table1.id and table2.`type`=22;

Will using an inner join be quicker or more efficient when selecting some 500+ rows at a time?

I've seen most examples using a inner join to do this.

possible duplicate of [ANSI vs. non-ANSI SQL JOIN syntax](http://stackoverflow.com/questions/1599050/ansi-vs-non-ansi-sql-join-syntax) — Tamim Al Manaseer, Jul 02 '13 at 16:26
I don't know where you are finding examples of inner joins like that. Just use an explicit `INNER JOIN` — Scotch, Jul 02 '13 at 16:26
You are using a JOIN in your example query, just using deprecated syntax. — Hart CO, Jul 02 '13 at 16:28
Quicker or more efficient than what? That IS an INNER JOIN; it's just written 'funny'. — Strawberry, Jul 02 '13 at 16:40

score 5 · Answer 1 · edited May 23 '17 at 12:10

5

No difference, just a syntax difference, internally they yield the same execution plan:

ANSI vs. non-ANSI SQL JOIN syntax

edited May 23 '17 at 12:10

Community

1
1

answered Jul 02 '13 at 16:30

Tamim Al Manaseer

3,554
3
24
33

score 3 · Accepted Answer · answered Jul 02 '13 at 16:25

3

You can do like this..

select table1.name, table1.description, 
table2.name, table2.description 
from table1 inner join Table2 on  table2.id=table1.id and table2.`type`=22

answered Jul 02 '13 at 16:25

Amit Singh

8,039
20
29

score 3 · Answer 3 · answered Jan 27 '17 at 05:40

3

This is the correct answer without join

select t1.*,t2.* from t1,t2 where t1.id=t2.id;

answered Jan 27 '17 at 05:40

Jitendra Parmar

33
4

Comma is cross join. (With lower precedence than keyword joins.) Also this doesn't answer the question. Also this query doesn't return what the query in the question does. – philipxy Feb 12 '21 at 11:57

Selecting data from two different tables without using joins

3 Answers3