DIR Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
  HTML https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: General
       *****************************************************
       #Post#: 8--------------------------------------------------
       using inner join afer left outer join scenarios
       By: srinivasma_exceldbp Date: February 10, 2014, 11:32 pm
       ---------------------------------------------------------
       --** This is an example how query behaves if inner join is added
       after left outer join
       --** It is very important to understand join concepts of the
       query
       declare  @a  table( keyid int,keyname varchar(50) )
       declare  @b  table( keyid int,keyname varchar(50) )
       declare  @c  table( keyid int,keyname varchar(50) )
       insert into @a  values (1,'10')
       insert into @a  values (2,'20')
       insert into @a  values (4,'40')
       insert into @a  values (6,'60')
       insert into @a  values (8,'80')
       insert into @a  values (9,'90')
       insert into @b  values (1,'100')
       insert into @b  values (3,'300')
       insert into @b  values (5,'500')
       insert into @b  values (6,'600')
       insert into @c  values (1,'1000')
       insert into @c  values (2,'2000')
       insert into @b  values (6,'6000')
       insert into @c  values (7,'7000')
       insert into @c  values (8,'8000')
       select a.* , b.*, c.*
       from @a a
       left outer join @b b --** Note: This can be changed to inner
       join and will give same result
       on a.keyid = b.keyid
       inner join @c c
       on c.keyid = b.keyid
       /*
gopher.createaforum.com:70 /forums/esdbp/p/7:43: port field too long