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. What’s the best way to search for a UPC code in a Database?
  16. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  17. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  18. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  19. What is the difference between UNION and UNION ALL?
  20. Selecting COUNT(*) with DISTINCT
  21. Case in Select Statement
  22. What is a stored procedure?
  23. ORA-00904: invalid identifier
  24. SQL WITH clause example [duplicate]
  25. Unknown column in ‘field list’ error on MySQL Update query
  26. Unknown column in ‘field list’ error on MySQL Update query
  27. SQL Inner-join with 3 tables?
  28. The wait operation timed out. ASP
  29. What is SELF JOIN and when would you use it? [duplicate]
  30. The wait operation timed out. ASP
  31. Conversion failed when converting date and/or time from character string while inserting datetime
  32. Self Join to get employee manager name
  33. How do I UPDATE from a SELECT in SQL Server?
  34. how to fix oracle ORA-01722 invalid number error
  35. SQL query to select dates between two dates
  36. MySQL – Operand should contain 1 column(s)
  37. SQL SELECT WHERE field contains words
  38. Conversion failed when converting date and/or time from character string while inserting datetime
  39. When should I use CROSS APPLY over INNER JOIN?
  40. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  41. Insert Data Into Temp Table with Query
  42. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  43. MySQL create table if not exists and insert record only if table was created
  44. error, string or binary data would be truncated when trying to insert
  45. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  46. NOT IN vs NOT EXISTS
  47. SQL SELECT WHERE field contains words
  48. Online SQL Query Syntax Checker
  49. How can I do an UPDATE statement with JOIN in SQL Server?
  50. Must declare the scalar variable
  51. ORA-00979 not a group by expression
  52. ORA-00907: missing right parenthesis
  53. How do I use properly CASE..WHEN in MySQL
  54. Must declare the scalar variable
  55. Rename column SQL Server 2008
  56. Why do we need “Relationships” between tables at all?
  57. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  58. Using group by on multiple columns
  59. Efficiently convert rows to columns in sql server
  60. How can I do a FULL OUTER JOIN in MySQL?
  61. Nested select statement in SQL Server
  62. PostgreSQL “DESCRIBE TABLE”
  63. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  64. Using group by on multiple columns
  65. SQL SELECT WHERE field contains words
  66. MySQL query String contains
  67. How do I escape a single quote in SQL Server?
  68. What’s the difference between VARCHAR and CHAR?
  69. Case statement in MySQL
  70. T-SQL split string based on delimiter
  71. How to declare a variable in MySQL?
  72. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  73. Finding duplicate values in a SQL table
  74. ORA-01843 not a valid month- Comparing Dates
  75. MySQL Cannot Add Foreign Key Constraint
  76. Drop a temporary table if it exists
  77. How do I escape a single quote in SQL Server?
  78. ORA-00918: column ambiguously defined in SELECT *
  79. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  80. How Stuff and ‘For Xml Path’ work in SQL Server?
  81. IDENTITY_INSERT is set to OFF – How to turn it ON?
  82. Oracle error : ORA-00905: Missing keyword
  83. How to split the name string in mysql?
  84. How to reset AUTO_INCREMENT in MySQL
  85. How do I import an SQL file using the command line in MySQL?
  86. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  87. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  88. mysql Foreign key constraint is incorrectly formed error
  89. How do I limit the number of rows returned by an Oracle query after ordering?
  90. Sql Server equivalent of a COUNTIF aggregate function
  91. Oracle SELECT TOP 10 records
  92. MySQL: Invalid use of group function
  93. must appear in the GROUP BY clause or be used in an aggregate function
  94. Column name or number of supplied values does not match table definition
  95. Inserting data into a temporary table
  96. Can a foreign key be NULL and/or duplicate?
  97. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  98. Why does NULL = NULL evaluate to false in SQL server
  99. How to Select Top 100 rows in Oracle?
  100. Simple PHP Pagination script

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)