Select using 2 instance of table

Question

Normally if I want to get an instance from table I use the following script :

SELECT STD_NAME FROM STUDENT S1 ,STUDENT S2

suppose student as an inner query like :

SELECT  std_name  FROM student, grades where student.id=grade.std_id) as S1

how can I use this inner query to make 2 instances ,with less coding.

shall I do some thing like :

(SELECT std_name  FROM student where student.id>=10) as S1 ,S2

I am using sql server 2008

Can you provide sample output? The question "how can I use this inner query to make 2 instances, with less coding" doesn't make sense (at least to me). — Gordon Linoff, Nov 05 '13 at 02:20

score 0 · Accepted Answer · edited Nov 05 '13 at 05:58

0

Why do you need to create 2 instances? They are equal.

But try:

( (Select x from A where A.x>=10) as S1) as S2

edited Nov 05 '13 at 05:58

Iswanto San

answered Nov 05 '13 at 02:31

Rui Martins

score 0 · Answer 2 · edited May 23 '17 at 12:03

0

Use INNER JOIN instead of Table1, Table2 which could have unintended consequence, like

SELECT std_name, grades.grade 
FROM student 
INNER JOIN grades 
ON student.id=grades.std_id
WHERE student.id>=10

edited May 23 '17 at 12:03

Community

answered Nov 05 '13 at 02:35

Edper

2 Answers2