1.

Solve : ACCESS HELP?

Answer»

im TRYING to grab one field from a table(HBATE.BATE), can placing it to another table(ATL)...like join/merge one UNIQUE field with another table...im having problems...i made this query...and its saying
the query...

SELECT bate, val, doc, BREAK, TASK, PATH
FROM ATL INNER JOIN HBATES
ON ATL.bate = HBATES.BATE;

this is the error i get
"the specified 'bate' could refer to more than one table listed in the FROM clause of your SQL statement"

can ANYONE TELL me what im doing wrong??
Try defining the table source of the bate field in the select statement:

Code: [Select]SELECT atl.bate, val, doc, BREAK, TASK, PATH
FROM ATL INNER JOIN HBATES
ON ATL.bate = HBATES.BATE;

OR

Code: [Select]SELECT hbates.bate, val, doc, BREAK, TASK, PATH
FROM ATL INNER JOIN HBATES
ON ATL.bate = HBATES.BATE;

By defining two tables in the FROM clause with same name fields, simply using the unqualified bate field name is ambiguous.

Good luck.


Discussion

No Comment Found

Related InterviewSolutions