Sign Up

Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In

Have an account? Sign In Now

Sign In

Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask question.(5)

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

ITtutoria

ITtutoria Logo ITtutoria Logo

ITtutoria Navigation

  • Python
  • Java
  • Reactjs
  • JavaScript
  • R
  • PySpark
  • MYSQL
  • Pandas
  • QA
  • C++
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Python
  • Science
  • Java
  • JavaScript
  • Reactjs
  • Nodejs
  • Tools
  • QA
Home/ Questions/Error: missing from-clause entry for table - how to solve it?
Next
Answered
Elyse Roberts
  • 32
Elyse Roberts
Asked: May 18, 20222022-05-18T19:37:41+00:00 2022-05-18T19:37:41+00:00In: sql

Error: missing from-clause entry for table – how to solve it?

  • 32

. Advertisement .

..3..

. Advertisement .

..4..

As advised, I used some code samples in another forum, but it could not improve the problem. My question is the “missing from-clause entry for table” in sql-how to solve it? The command line is:

SELECT 
  AcId, AcName, PldepPer, RepId, CustCatg, HardCode, BlockCust, CrPeriod, CrLimit, 
  BillLimit, Mode, PNotes, gtab82.memno 
 FROM
  VCustomer 
 INNER JOIN 
  vcustomer AS v1 ON gtab82.memacid = v1.acid 
 WHERE (AcGrCode = '204' OR CreDebt = 'True') 
 AND Masked = 'false'
 ORDER BY AcName

and the result:

missing FROM-clause entry for table "gtab82"

What does the message mean? Can you advise me to fix it? If you have other better answers, leave them in the answer box below.

missing from clause entry for table
  • 2 2 Answers
  • 832 Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook
  • Report

2 Answers

  • Voted
  • Oldest
  • Recent
  • Random
  1. Best Answer
    lyytutoria Expert
    2022-06-25T01:38:51+00:00Added an answer on June 25, 2022 at 1:38 am

    The cause:

    This error happens because your FROM or JOIN clauses do not include the gtab82 table. Another reason is that an alias name is used for a table but the WHERE clause does not include it.

    Solution:

    Only when you need to prefix a column with the table name because there are duplicate column names in the connected tables and the table name is large or when the table is joined to itself should you use an alias for the table name. In your situation, VCustomer has an alias, but you only use it in the ON clause for unknown reasons. You had better check that section of your code.

    SELECT
    AcId, AcName, PldepPer, RepId, CustCatg, HardCode, BlockCust, CrPeriod, CrLimit,
    BillLimit, Mode, PNotes, gtab82.memno
    FROM
    VCustomer AS v1
    INNER JOIN
    gtab82 ON gtab82.memacid = v1.AcId
    WHERE (AcGrCode = '204' OR CreDebt = 'True')
    AND Masked = 'false'
    ORDER BY AcName
    • 0
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report
  2. Mohamed Pascal
    2022-05-25T20:56:02+00:00Added an answer on May 25, 2022 at 8:56 pm

    Because the gtab82 table doesn’t belong in your FROM clause or JOIN. These cases refer to the gtab82 tables: gtab82.memno, gtab82.memacid

    • 23
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report

Leave an answer
Cancel reply

You must login to add an answer.

Forgot Password?

Need An Account, Sign Up Here

Sidebar

Ask A Question
  • How to Split String by space in C++
  • How To Convert A Pandas DataFrame Column To A List
  • How to Replace Multiple Characters in A String in Python?
  • How To Remove Special Characters From String Python

Explore

  • Home
  • Tutorial

Footer

ITtutoria

ITtutoria

This website is user friendly and will facilitate transferring knowledge. It would be useful for a self-initiated learning process.

@ ITTutoria Co Ltd.

Tutorial

  • Home
  • Python
  • Science
  • Java
  • JavaScript
  • Reactjs
  • Nodejs
  • Tools
  • QA

Legal Stuff

  • About Us
  • Terms of Use
  • Privacy Policy
  • Contact Us

DMCA.com Protection Status

Help

  • Knowledge Base
  • Support

Follow

© 2022 Ittutoria. All Rights Reserved.

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.