Inner Join


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Inner Join

  1. #1
    Join Date
    Jan 2007
    Posts
    41

    Inner Join

    Is there a way to add a where clause in the following statement?

    "SELECT * FROM MemberInfo INNER JOIN TournamentDetails ON MemberInfo.UserID=TournamentDetails.PlayerID"

    ... I would like to add something like WHERE MemberInfo.UserID='PL1001'

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Uh...yes? Have you tried it?
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Jan 2007
    Posts
    41
    hahah yeah. it gives me a syntax error.

  4. #4
    Join Date
    Jan 2007
    Posts
    41
    ummmmmm nm.... it does work. Thanks

  5. #5
    Join Date
    Dec 2003
    Posts
    2,750
    What kind of database? What is the exact error?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Similar Threads

  1. JOIN physical location vs ON location
    By LuluDev in forum Database
    Replies: 2
    Last Post: 02-13-2007, 10:32 AM
  2. inner join and outer join
    By syedwna in forum Database
    Replies: 11
    Last Post: 09-02-2006, 05:24 AM
  3. Add table to view
    By franklch in forum Database
    Replies: 3
    Last Post: 05-19-2005, 04:39 PM
  4. JOIN vs WHERE clause.
    By Igor in forum Database
    Replies: 2
    Last Post: 12-31-2002, 10:53 AM
  5. Problem with stored procedure
    By yip in forum Database
    Replies: 1
    Last Post: 09-24-2002, 12:31 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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center