Skip to main content
Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding Qualify Statement

Hi,

In the example given in the attached screen shot, author has used table name as  [Origin Airports]:

Can I give any random table name XYZ ?

Also, the very first line states- field name will get qualified with their corresponding table names. Here I am finding the word "Corresponding" a little confusing. What does author wants to suggest by it ?.. As per my understanding, Suppose instead of [Origing Airports]: I used table name as [XYZPQR], then the resulting field names will be XYZPQR.Code  and XYZPQR.Description. 


1 Solution

Accepted Solutions
Gysbert_Wassenaar

Yes, to both questions. You can give any table any name you want. The name you give a table will be used as the field prefix if you use the Qualify keyword.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Yes, to both questions. You can give any table any name you want. The name you give a table will be used as the field prefix if you use the Qualify keyword.


talk is cheap, supply exceeds demand