Professional Web Applications Themes

Rewrite Query using Inner Join, Left Join e.t.c - Microsoft SQL / MS SQL Server

Using ansi standard syntax your query would look like: select C1.CompanyName as Customer, C2.CompanyName as Depot, C3.CompanyName as Outlet from tblCompanies C1 inner join tblCustomerDepot CD on and C1.CompanyId = CD.CustomerId inner join tblCompanies C2 on C2.CompanyId = CD.DepotId inner join tblCustomerOutlet CO on C1.CompanyId = CO.CustomerId inner join tblCompanies C3 on C3.CompanyId = CO.OutletId where C1.GroupId = 91 and C2.GroupId = 93 and C3.GroupId = 92 -Vishal   it using the more  if you need DDL or ...

  1. #1

    Default Re: Rewrite Query using Inner Join, Left Join e.t.c

    Using ansi standard syntax your query would look like:

    select
    C1.CompanyName as Customer,
    C2.CompanyName as Depot,
    C3.CompanyName as Outlet
    from
    tblCompanies C1 inner join tblCustomerDepot CD
    on and C1.CompanyId = CD.CustomerId
    inner join tblCompanies C2
    on C2.CompanyId = CD.DepotId
    inner join tblCustomerOutlet CO
    on C1.CompanyId = CO.CustomerId
    inner join tblCompanies C3
    on C3.CompanyId = CO.OutletId
    where C1.GroupId = 91
    and C2.GroupId = 93
    and C3.GroupId = 92

    -Vishal
     
    it using the more 
    if you need DDL or 
    Vishal Guest

  2. #2

    Default Rewrite Query using Inner Join, Left Join e.t.c

    select
    C1.CompanyName as Customer,
    C2.CompanyName as Depot,
    C3.CompanyName as Outlet
    from
    tblCompanies C1
    INNER JOIN tblCustomerDepot CD ON C1.CompanyId =
    CD.CustomerId
    INNER JOIN tblCustomerOutlet CO ON C1.CompanyId =
    CO.CustomerId
    INNER JOIN tblCompanies C2 ON C2.CompanyId = CD.DepotId
    INNER JOIN tblCompanies C3 ON C3.CompanyId = CO.OutletId
    where
    C1.GroupId = 91
    and C2.GroupId = 93
    and C3.GroupId = 92
     
    it using the more 
    you need DDL or 
    AngelWPB Guest

  3. #3

    Default Re: Rewrite Query using Inner Join, Left Join e.t.c

    I would format this as (hope it doesn't lose the formatting

    select
    C1.CompanyName as Customer,
    C2.CompanyName as Depot,
    C3.CompanyName as Outlet
    from
    tblCompanies C1
    inner join tblCustomerDepot CD
    on C1.CompanyId =
    CD.CustomerId
    inner join tblCompanies C2
    on C2.CompanyId = CD.DepotId
    inner join tblCustomerOutlet CO
    on C1.CompanyId = CO.CustomerId
    inner join tblCompanies C3
    on C3.CompanyId = CO.OutletId
    where C1.GroupId = 91
    and C2.GroupId = 93
    and C3.GroupId = 92
    Nigel Guest

  4. #4

    Default Re: Rewrite Query using Inner Join, Left Join e.t.c

    Thanks to you all, it's always easier to understand new things when you can
    relate it to something you're working on!

    "London Developer" <com> wrote in message
    news:phx.gbl... 


    London Guest

Similar Threads

  1. Is left-join faster then inner join?
    By howachen@gmail.com in forum MySQL
    Replies: 5
    Last Post: March 5th, 07:11 AM
  2. Sql Left Join Help
    By Marc.Farrow in forum MySQL
    Replies: 8
    Last Post: October 9th, 06:00 PM
  3. SQL query with a Left outer Join
    By Ad Bec in forum Coldfusion Database Access
    Replies: 2
    Last Post: April 22nd, 04:48 AM
  4. Replies: 2
    Last Post: September 18th, 09:59 PM
  5. Select Left Join AND Right Join
    By David in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 15th, 03:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139