Results 1 to 5 of 5
  1. #1
    amanthethi is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    7

    Can anybody tell me the meaning ogf this SQL Command, please

    SELECT Completion_checklist.*, Phase.Phase_ID AS Phase_ID_Phase
    FROM Phase INNER JOIN Completion_checklist ON (Phase.Phase_ID = Completion_checklist.Phase_ID);


    Best Regards
    Aman

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    they are pulling data from table/qry [Completion_checklist] joined to table/qry PHASE,
    on field: PhaseID.



  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    In layman's terms
    SELECT all fields (*) from the table named Completion_checklist AND Phase_ID FROM Phase table (but let's call that Phase_ID_Phase) FROM these aforementioned tables BUT what is in Phase.Phase_ID record has to match (be equal to) what's in each record of Completion_checklist.Phase_ID.

    I'm not smart but I do know how to use Google
    https://support.microsoft.com/en-us/...4-e8dc3e460671
    Last edited by Micron; 02-12-2021 at 02:50 PM. Reason: clarification
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Quote Originally Posted by Micron;470892
    I'm not smart but I do know how to use Google
    [URL
    https://support.microsoft.com/en-us/office/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671[/URL]
    Appears to be a lost art these days.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

    @Welshgasman
    Now that's FUNNY!!!


    Thanks.. I needed that....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-03-2019, 05:07 AM
  2. What's the meaning of board friends?
    By davegri in forum Forum Suggestions
    Replies: 1
    Last Post: 12-15-2018, 11:17 AM
  3. Meaning of Prefixes
    By Lou_Reed in forum Access
    Replies: 6
    Last Post: 03-23-2017, 05:22 PM
  4. rs.EOF Meaning
    By jo15765 in forum Modules
    Replies: 2
    Last Post: 03-18-2015, 06:34 PM
  5. What is the meaning of this query?
    By doci4a in forum Queries
    Replies: 2
    Last Post: 03-15-2011, 07:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums