JOIN with Multiple tables

 select A.item_id,A.value as DocID,B.Value as FamilyID,C.value as SDO,D.*

from [Item_Detail](nolock) A

inner join [Item_Detail](nolock) B

on A.item_id = B.item_id

inner join [Item_Detail](nolock) C

on A.item_id = C.item_id

left outer join [Item_Detail](nolock) D 

on A.item_id = D.item_id and D.attribute_id='FC0DAAD6-7820-4DA1-AA77-CCF7780038E9'

--giving at where clause is ok untill unless there is an existing row in the table, if there is no row

--then we wont get the desired result. So better to use 'AND D.attribute_id='FC0DAAD6-7820-4DA1-AA77-CCF7780038E9'' at 'ON CLAUSE' itself even

--if there is some performance issue

where A.item_id = '68687B00-A22D-48A8-83FF-00000536E871'

and A.attribute_id = 'FAA27652-97E8-4FBA-88EB-C77EC82C4109'

and C.attribute_id = '5F859754-9FC4-4072-A054-41BF40F21A3B'

and B.attribute_id = '925412D0-7574-46A6-B3BA-4C1111549456'

Comments

Post a Comment

Popular posts from this blog

Understanding Collection and Object Initializer

Image
  collection - we use it when we want to group objects of different types into one bucket. Remember that each item in a collection is an object. Example ArrayList adds all items in the form of objects so we were taking out values from the ArrayList instance then we must type from object type to its corresponding type   Here item is of object type, and we are type casting it to its corresponding type. collection Initializer - The group of object initializers are nothing but collection Initializer       Object Initialzier - It is used to initialize the data members or properties of a class.To avoid creating multiple constructor of a class, we go for Object Initialzier. Object   initializers creates parameterless constructor internally. The curly braces opening and closing is called Object   initializers block.  
Read more

How to execute Javascript in VS code

Image
S1 : install node software s2 : install VS code software s3 : Open VS code editor. Open the extensions windows. Install two software   JavaScript (ES6) snippets Code Runner - By Jun Han s4 : Open new terminal window and type "npm install prompt-sync" --->This is used to prompt user input s5 : Type the JavaScript code as shown in the below screenshot. s6 : There is Run button on the right side of the window. Click on it to run the program. s7:  Console will ask for input from the user, if it is not allowing to edit then do the following open settings and type code runner and then put a check mark on that option. s8: Re-run the program                
Read more