sql server support,sql interview questions
Saturday, 16 April 2011
Joins between table and View?
Yes it’s possible
create
view
v_getemp
as
select
*
from
emp
(In emp table I have 3 columns)
select
*
from
v_getemp
inner
join
emp
on
emp
.
eid
=
v_getemp
.
eid
Result : I will get 6 columns
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment