missing FROM-clause entry for table

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

You typically only use an alias for a table name when you need to prefix a column with the table name due to duplicate column names in the joined tables and the table name is long or when the table is joined to itself. In your case you use an alias for VCustomer but only use it in the ON clause for uncertain reasons. You may want to review that aspect of your code.

Related Posts:

  1. Insert text with single quotes in PostgreSQL
  2. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  3. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  4. Postgresql tables exists, but getting “relation does not exist” when querying
  5. postgresql: error duplicate key value violates unique constraint
  6. pg_ctl: no database directory specified and environment variable PGDATA unset
  7. Postgres Error: More than one row returned by a subquery used as an expression
  8. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  9. PostgreSQL create table if not exists
  10. updating table rows in postgres using subquery
  11. PostgreSQL visual interface similar to phpMyAdmin?
  12. GROUP BY and COUNT using ActiveRecord
  13. Postgresql column reference “id” is ambiguous
  14. What is a postgres superuser
  15. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  16. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  17. SQL WITH clause example [duplicate]
  18. The wait operation timed out. ASP
  19. SQL query to select dates between two dates
  20. MySQL – Operand should contain 1 column(s)
  21. SQL SELECT WHERE field contains words
  22. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  23. NOT IN vs NOT EXISTS
  24. Must declare the scalar variable
  25. ORA-00979 not a group by expression
  26. How can I do a FULL OUTER JOIN in MySQL?
  27. MySQL query String contains
  28. Finding duplicate values in a SQL table
  29. MySQL Cannot Add Foreign Key Constraint
  30. Oracle error : ORA-00905: Missing keyword
  31. How do I import an SQL file using the command line in MySQL?
  32. mysql Foreign key constraint is incorrectly formed error
  33. Can a foreign key be NULL and/or duplicate?
  34. How do composite indexes work?
  35. Difference between JOIN and INNER JOIN
  36. MySQL “WITH” clause
  37. What is the difference between JOIN and UNION?
  38. MySQL Multiple Joins in one query?
  39. Error Code: 2013. Lost connection to MySQL server during query
  40. “CASE” statement within “WHERE” clause in SQL Server 2008
  41. SQL join on multiple columns in same tables
  42. ORA-00972 identifier is too long alias column name
  43. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  44. Sql query – getting rid of hard-coded values
  45. ORA-00918: column ambiguously defined in SELECT *
  46. How To Run A Github Repository?
  47. SQL Switch/Case in ‘where’ clause
  48. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  49. SQL Server WITH statement
  50. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  51. Algebra Relational sql GROUP BY SORT BY ORDER BY
  52. Oracle “Partition By” Keyword
  53. What is the equivalent of ‘describe table’ in SQL Server?
  54. Add a column with a default value to an existing table in SQL Server
  55. Cannot simply use PostgreSQL table name (“relation does not exist”)
  56. Cast from VARCHAR to INT – MySQL
  57. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  58. Using group by on multiple columns
  59. What is the purpose of using WHERE 1=1 in SQL statements?
  60. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  61. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  62. How do you force mysql LIKE to be case sensitive?
  63. What is the difference between a stored procedure and a view?
  64. Bulk load data conversion error (truncation)
  65. Insert into a MySQL table or update if exists
  66. Convert timestamp to date in Oracle SQL
  67. How to order by with union in SQL?
  68. Update statement with inner join on Oracle
  69. Incorrect syntax near ”
  70. MySQL: Can’t create table (errno: 150)
  71. Join vs. sub-query
  72. Alternative to except in MySQL
  73. DATEDIFF function in Oracle
  74. MySQL – Get row number on select
  75. What does * mean in sql?
  76. How to truncate the text returned for a column in a MySQL query
  77. INSERT VALUES WHERE NOT EXISTS
  78. Using union and order by clause in mysql
  79. Difference between `load data inpath ` and `location` in hive?
  80. How to implement LIMIT with SQL Server? [duplicate]
  81. How To Write An Inner Join With WP Query
  82. Update user_login, user_nicename, and display_name
  83. Change sticky status of posts from phpMyAdmin
  84. Fetch all Posts where logged in user has commented
  85. Needing to move content from postmeta to posts in sql [closed]
  86. How to import a Typo3 database to a wordpress site?
  87. What does the $posts_join filter join to?
  88. Clean up very big and very dirty database
  89. How to delete ALL comments from certain category in WordPress database?
  90. How can I convert everything from category X to have post format Link
  91. Bulk delete WordPress Post and all metadata, etc using SQL query
  92. What steps do I need to take to install a local copy of a live website?
  93. Reset post IDs with all post meta
  94. How to Add or Change Post Title
  95. Why does DROP TABLE-ing the `wp_options` reset my user session?
  96. How to refactor DB queries for better TTFB in WordPress?
  97. query sql-table and change entities
  98. Analog category_and (WP) in sql query
  99. Backtick (MySQL norm) added to SQL Server Query causing error
  100. GRANT SELECT to all tables in postgresql

Leave a Comment

tech