Please help Urgent SQL query RSS

• • Reply
  Samkoukou

  Member

  1 Points

  4 Posts

  Please help Urgent SQL query

  Sep 29, 2020 09:54 AM|Samkoukou|LINK

  I am using Access database Please help me in SQL query 

   have 2 tables like below:

  Tbl_Employee                                  Tbl_Destination

  ---------------                                   --------------------

  IdEmployee                                      Id_Destination

  Name                                               Destination_Name

  Id_Trip_Source

  Id_Trip_Destination

  I need help to output like Below

  Emp_Name           Source                 Destination

  -----------------------------------------------------

  John Doo              Germany              Canada

  Tony Montana      Brazil                    Egypt

  Suzan Jimba          Norway                Sweeden

  Destination (Egpt,Brazil,Canada) are stored in Tbl_Destination in the field Destination_Name 

  I am using Access Database and asp.net

   

• • Reply
  Lannie

  Contributor

  3422 Points

  1335 Posts

  Re: Please help Urgent SQL query

  Oct 09, 2020 03:38 AM|Lannie|LINK

  SELECT
    a.NAME                    AS Emp_Name,
    a.Id_Trip_Source       AS Source,
    b.Destination_Name AS Destination
  FROM
    Tbl_Employee a
  LEFT OUTER JOIN Tbl_Destination b ON a.Id_Trip_Destination = b.Id_Destination
  /

  you do not specify of the SOURCE name is also stored in the destination table or in a separate "source" name table.

  You would have to add LEFT OUTER JOIN to support the lookup to the SOURCE name

• • Reply
  yij sun

  Contributor

  2570 Points

  1017 Posts

  Re: Please help Urgent SQL query

  Oct 13, 2020 06:57 AM|yij sun|LINK

  Hi Samkoukou,

  Accroding to your description,could you tell us  what the relationship of two tables.

  As far as I think,you could join two tables.However,these two tables must have primary key , foreign key  and relationship.

  Syntax:

  FROM table1 [ LEFT | RIGHT ] JOIN table2 ON table1.field1 compopr table2.field2

  More details,you could refer to below article:

  https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/left-join-right-join-operations-microsoft-access-sql

  Best regards,

  Yijing Sun

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.