using JOINS

Report
Question

Please briefly explain why you feel this question should be reported .

Report
Cancel

please i want to know how joins used in more than 5 tables so pls give one solutions with example.

closed 0
SQL 2 months 5 Answer 3162 views 0

About santosh

Answers ( 5 )

  1. rg123

    Please briefly explain why you feel this answer should be reported .

    Report
    Cancel

    More than 5 tables are joined exactly the same as 2/3 tables.
    You will get information from here regarding Joining three or more tables.
    Hope this helps!

  2. Please briefly explain why you feel this answer should be reported .

    Report
    Cancel

    Hi,
    Guys can you please provide me the architecture of your table so that i could provide you answer.

  3. Please briefly explain why you feel this answer should be reported .

    Report
    Cancel

    using simple join querry . which type of data are you requried .

  4. Please briefly explain why you feel this answer should be reported .

    Report
    Cancel

    Something like this:

    SELECT SalesLT.Product.Name, 
    SalesLT.Product.ProductNumber, 
    SalesLT.ProductCategory.Name AS "Product Category",
    SalesLT.ProductModel.Name AS "Product Model", 
    SalesLT.ProductModelProductDescription.ModifiedDate,
    SalesLT.ProductDescription.Description
    FROM SalesLT.Product 
    INNER JOIN SalesLT.ProductCategory ON SalesLT.Product.ProductCategoryID = SalesLT.ProductCategory.ProductCategoryID 
    INNER JOIN SalesLT.ProductModel ON SalesLT.Product.ProductModelID = SalesLT.ProductModel.ProductModelID 
    INNER JOIN SalesLT.ProductModelProductDescription ON SalesLT.ProductModel.ProductModelID = SalesLT.ProductModelProductDescription.ProductModelID 
    INNER JOIN SalesLT.ProductDescription ON SalesLT.ProductModelProductDescription.ProductDescriptionID = SalesLT.ProductDescription.ProductDescriptionID
    
  5. Please briefly explain why you feel this answer should be reported .

    Report
    Cancel

    Hi
    Making 5 table join , its not a good solution for query performance, If data amount is huge than it will take long time and on production it is not good way.

Leave an answer