Aliases in SQL (1 Viewer)

jaryszek · May 31, 2019

Hi,

i have sql like here:

Code:

SELECT qryIm_Temp_SystemVersionsNMtblSystemVersions3.*, tblSystemVersions.SystemVersionID
FROM qryIm_Temp_SystemVersionsNMtblSystemVersions3 INNER JOIN tblSystemVersions ON (qryIm_Temp_SystemVersionsNMtblSystemVersions3.VersionName = tblSystemVersions.VersionName) 
AND (qryIm_Temp_SystemVersionsNMtblSystemVersions3.BundleID = tblSystemVersions.BundleID) AND (qryIm_Temp_SystemVersionsNMtblSystemVersions3.Function = tblSystemVersions.Function) AND (qryIm_Temp_SystemVersionsNMtblSystemVersions3.VersionID = tblSystemVersions.VersionID);

where can i use aliases for tables?

please help,
Jacek

Minty · May 31, 2019

Intead of
FROM qryIm_Temp_SystemVersionsNMtblSystemVersionq3
Use
FROM qryIm_Temp_SystemVersionsNMtblSystemVersions3 Q3 <--- The Alias
Then
Select q3.* etc etc

Edited the Typo !

jaryszek · May 31, 2019

hi Minty,

thank you,

not working:

https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=75063&stc=1&d=1559299837

Best,
Jacek

Minty · May 31, 2019

Sorry typo that should be

Q3.*

Table then field reference , doh must be a Friday...

theDBguy · May 31, 2019

Hi Jacek. When you assign an alias to a table, you’ll have to use the alias in place of the table name everywhere in your query. You can’t use a mixed syntax.

rpeare · May 31, 2019

Also, you don't use AS when you alias your table, only your field names

Select TESTFIELD as OMGTEST
from qryIm_Temp_SystemVersionsNMtblSystemVersions3 Q3

TESTFIELD is aliased to OMGTEST
qryIm_Temp_SystemVersionsNMtblSystemVersions3 is aliased to Q3

jaryszek · May 31, 2019

oo thank you, Very nice to know this.

I will test approach.

Best,
Jacek

theDBguy · May 31, 2019

jaryszek said:
oo thank you, Very nice to know this.

I will test approach.

Best,
Jacek

Hi. Just FYI. I think the AS part is optional. You don't have to use it, but it doesn't mean you can't. Cheers!

jaryszek · May 31, 2019

hmm still this is not working:

Jacek

theDBguy · May 31, 2019

jaryszek said:
hmm still this is not working:

Jacek

Hi Jacek. Did you see my comment earlier. You'll have to use the alias everywhere, once you assigned it. For example:

Code:

SELECT [COLOR=red]Q3[/COLOR].*
FROM Query1 AS [COLOR=Red]Q3[/COLOR]
INNER JOIN Query2
 ON [COLOR=red]Q3[/COLOR].FieldName=Query2.FieldName
WHERE [COLOR=Red]Q3[/COLOR].FieldName=SomeValue

jaryszek · May 31, 2019

aaa ok thank you, understand know!

Jacek

theDBguy · May 31, 2019

jaryszek said:
aaa ok thank you, understand know!

Jacek

You're welcome. Good luck. Hope it works...

Aliases in SQL (1 Viewer)

jaryszek

Registered User.

Minty

AWF VIP

jaryszek

Registered User.

Attachments

Minty

AWF VIP

theDBguy

I’m here to help

rpeare

Registered User.

jaryszek

Registered User.

theDBguy

I’m here to help

jaryszek

Registered User.

Attachments

theDBguy

I’m here to help

jaryszek

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread