CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Join

  1. August 9th, 1999, 09:32 AM #1
    Jonas Bergman
    Jonas Bergman is offline Junior Member
    Join Date
    Aug 1999
    Posts
    3

    Join

    In Access, how can I join one Table with a Select Statement, e.g.
    Club Left Join (Select...)
    instead of first creating one query and joining the table on this query e.g.
    Club Left Join Query1

    Reply With Quote Reply With Quote
  2. August 10th, 1999, 02:28 AM #2
    Lothar Haensler
    Lothar Haensler is offline Elite Member
    Join Date
    May 1999
    Posts
    3,332

    Re: Join

    syntax goes something like that:

    SELECT * FROM firsttable LEFT JOIN secondtable ON firsttable.keyfield = secondtable.keyfield

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured