 <pre><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 </code></pre> <p>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 <code>VCustomer</code> but only use it in the <code>ON</code> clause for uncertain reasons. You may want to review that aspect of your code.</p>