Quote:
Originally Posted by cjard
ID is an alias for the IDENTIFICATION_DATA table(, and it is used)
AO is an alias for the AOP5 table, but the alias is not used so there is no point in having it
I thought Access used MID() for substringing, not SUBSTRING
|
Oops used ao in the WHERE clause but not SET
Access does use MID(). I gave him an example
here