2 table Query Error

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: GRCC (grccnews_at_nospamadelphia.net)
Date: 11/26/04 

Date: Fri, 26 Nov 2004 13:30:08 -0500

The specified field <number> could refer to more than one table listed in
the FROM clause of your SQL statement. (Error 3079)
This is the error message I get. I have a query that works nicely pulling
info from one table. I need to add a second table from the same DB to pull 2
more items. It is a Country club member accounting database. When I add the
2nd table and specify the 2 fields I need (the relationships are correct,
member ID to member ID) I get the afore memtioned error message. The 2
tables both have a number feild (same data) is this the problem? I have
tried adding the number field a second time, each one indicating which table
to pull from. So why ? I am beginning to think that the program is flawed
and poorly written because first theused number as a field, but to make it
worse they used number as a field in 2 different tables. Any Ideas?
Thanks So Much
GRCC

Relevant Pages

  • Re: UINT16 error
    ... > This has got nothing to do with managed vs unmanaged code or UINT16. ... > Apparently NewNetwork is a non-static member function, ... it's emitting a misleading error message which ... > implies it's a static member. ...
    (microsoft.public.dotnet.languages.vc)
  • Re: C to C++
    ... It looks like you're on the right track this time, but since I can't see the relevant code or ... the exact error message, I can't be sure you did it right. ... You named your wrapper function with the same name as the member -- is the compiler confused about ... implied first parameter which is a 'this' pointer, making the function ...
    (microsoft.public.vc.language)
  • Re: The specified field could refer to more than one table listed in the FROM clause of your SQL st
    ... I'm getting the error message that ... "The specified field could refer to more than one table listed in the ... delimiter is for form objects; ... Are any of the JOINs joining to stored queries instead of tables? ...
    (microsoft.public.access.queries)
  • Re: how to send from a distribution list
    ... I still get error message: you do not have permission ... ... sendfrom typed: ... is it possible for a member of a distribution list send email from ...
    (microsoft.public.exchange.admin)
  • Re: ADAM Authentication in ASP.NET
    ... Out of curiosity, what groups is that user a member of? ... > Following is the error message I am getting when trying to authenticate ...
    (microsoft.public.windows.server.active_directory)