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
Post a Comment