Re: alias...don't alias at all
From: Andreas (nobody_at_home.com)
Date: 03/25/05
- Next message: mscertified: "How code 2 left joins in UPDATE sql ???"
- Previous message: Andreas: "Re: look-back thru historical MDB 4 no. combinations w/o re. 2 the"
- In reply to: rocco: "alias...don't alias at all"
- Next in thread: Van T. Dinh: "Re: alias...don't alias at all"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 26 Mar 2005 10:53:04 +1200
Have a look at the table in design view.
Is the "Caption" property for this field set?
If so, that is the culprit.
Regards,
Andreas
rocco wrote:
> Hello,
> i have this statement
>
> SELECT DSPC_PATIENT.ID, C_PROTO.ID AS [in c_proto]
> FROM DSPC_PATIENT LEFT JOIN C_PROTO ON DSPC_PATIENT.ID = C_PROTO.ID IN
> 'C:\Documents and Settings\rocco n forgione\My
> Documents\CLIENTS\GRANT\grant_2000.mdb'
> WHERE (((DSPC_PATIENT.ID)>35));
>
> Well... despite the "AS"...I still see the the original column names in
> table instead of the name I decided with "AS" in the statement.
> Something wrong?
- Next message: mscertified: "How code 2 left joins in UPDATE sql ???"
- Previous message: Andreas: "Re: look-back thru historical MDB 4 no. combinations w/o re. 2 the"
- In reply to: rocco: "alias...don't alias at all"
- Next in thread: Van T. Dinh: "Re: alias...don't alias at all"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
