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