SQL Join excel vba

Question

I am trying to run the following SQL query in access VBA and I am getting a join error.

I can't seem to figure out what the problem is. I'm sure there's something obvious I am just overlooking.

SELECT a.LateDate, a.LateAgent, a.LateTime, b.PBXID,
       (b.FirstName + ' ' + b.Surname) as FullName
from tblLateLog a
    INNER Join tblAgents b on a.LateAgent = FullName

You can't use column aliases in the ON clause. Do ON a.LateAgent = (b.FirstName + ' ' + b.Surname). — jarlh
– jarlh, Commented Mar 2, 2016 at 11:31
Please remove the excel-vba tag as this isn't anything to do with Excel — SierraOscar
– SierraOscar, Commented Mar 2, 2016 at 11:40

jarlh · Accepted Answer · 2016-03-02 11:31:52Z

2

You can't use column aliases in the ON clause:

SELECT a.LateDate, a.LateAgent, a.LateTime, b.PBXID,
       (b.FirstName + ' ' + b.Surname) as FullName
from tblLateLog a
    INNER Join tblAgents b ON a.LateAgent = (b.FirstName + ' ' + b.Surname)

answered Mar 2, 2016 at 11:31

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jorge Campos · Accepted Answer · 2016-03-02 11:31:40Z

0

You can't use an alias in the same context of your query to do a join. Do as this:

SELECT a.LateDate, a.LateAgent, a.LateTime, b.PBXID,
       (b.FirstName + ' ' + b.Surname) as FullName
  FROM tblLateLog a
     INNER Join tblAgents b on a.LateAgent = (b.FirstName + ' ' + b.Surname)

answered Mar 2, 2016 at 11:31

Jorge Campos

23.8k7 gold badges65 silver badges95 bronze badges

Collectives™ on Stack Overflow

SQL Join excel vba

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related