The column prefix does not match with a table name or alias name used in


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: The column prefix does not match with a table name or alias name used in

  1. #1
    Join Date
    Aug 2006
    Location
    PA
    Posts
    259

    The column prefix does not match with a table name or alias name used in

    Help, I'm try to do this query : select * from CivilHeader where CivilHeader.CaseNumber = Judgment1.Casenumber but I get this error and dont know what is causing it : The column prefix 'Judgment1' does not match with a table name or alias name used in the query.



    Judgment1 is a table not a column so the error message makes no sense

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    You must include all tables referenced by the query in the FROM clause. Your FROM clause does not include a table named Judgment1, thus the error.

    Try this:

    SELECT * FROM CivilHeader, Judgment1
    WHERE CivilHeader.CaseNumber = Judgment1.CaseNumber
    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!

Similar Threads

  1. Validate user entry against table column
    By Paulette in forum Web
    Replies: 1
    Last Post: 06-17-2002, 06:40 PM
  2. XML to 3 column table
    By Eric in forum XML
    Replies: 0
    Last Post: 09-06-2001, 07:03 PM
  3. Hiding column of a table
    By maya in forum ASP.NET
    Replies: 3
    Last Post: 07-11-2001, 10:40 AM
  4. Multi-row calculations
    By Bob Hines in forum Database
    Replies: 7
    Last Post: 04-27-2000, 12:14 PM
  5. Re: adding column to table
    By sarah in forum Database
    Replies: 0
    Last Post: 04-19-2000, 12:14 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