sql server - Inner join two query and alias -


i want inner join 2 set 2 query. it's not working.

here code:

(select model pc) t1 inner join (select model laptop) t2 on t1.model = t2.model 

it appear error on 2 alias t1, t2

pls me

@deanosaur: here schema: http://i.stack.imgur.com/sxtoy.jpg

try , see if gets closer want.

select * pc t1 inner join laptop t2 on t1.model=t2.model; 

Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -