Results 1 to 4 of 4

Thread: checking values

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: checking values

    Can any one offer any help please, how do i create a query that searches fields in 1 table to find matching values stored in a field containing the query i.e

    ball 1 in table 1 checks ball 1, ball 2, ball 3 in table 2 to see if there is a match?

    help will be appreciated!

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: checking values

    SELECT Table.*
    FROM TABLE1, TABLE2
    WHERE TABLE1.BALL=TABLE2.BALL
    In abundance of water only the fool is thirsty. Bob Marley.

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Re: checking values

    Originally posted by rami.haddad
    SELECT Table.*
    FROM TABLE1, TABLE2
    WHERE TABLE1.BALL=TABLE2.BALL
    cheers for the help but couldn't sort it out, this is what I tried:

    Select * FROM tblMember, tblWinningNumbers Where tblMember.numberOne = tblWinningNumbers.wNumberOne

    It kept saying the syntax in the subquery is wrong, any ideas?

    Cheers.

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: checking values

    Originally posted by MillerLight
    cheers for the help but couldn't sort it out, this is what I tried:

    Select * FROM tblMember, tblWinningNumbers Where tblMember.numberOne = tblWinningNumbers.wNumberOne

    It kept saying the syntax in the subquery is wrong, any ideas?

    Cheers.
    You have an ambiguous "*" ... Try: Select tblMember.* FROM tblMember ...

Posting Permissions

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