Skip to main content
Learning Documentation Community Open Exchange Ideas Portal Global Masters Certification Partner Directory Startup Hub
Search by posts, members, tags
Menu English
  • Posts
    • InterSystems Official
    • Articles
    • Announcements
    • Questions
    • Discussions
    • Tags
  • Events
    • Event Calendar
    • InterSystems Idea-A-Thon
    • Programming Contest
  • Products
    • InterSystems IRIS
    • InterSystems IRIS for Health
    • HealthShare
    • TrakCare
    • Caché
    • Ensemble
    • InterSystems Analytics (DeepSee)
    • InterSystems Text Analytics (iKnow)
  • Jobs
    • Job Opportunity
    • Job Wanted
  • Members
  • About
    • About Us
    • FAQ
    • Feedback
    • Report an Issue
    • Share an Idea
    • Code of Conduct
    • Contact Us
Ask AI
EN
  • EN
  • JP
  • ES
  • PT
  • FR
  • CN
  • Profile page
  • Posts (1)
  • Replies (1)
  • Mentions (1)
  • Official certification & Credly badges (0)
  • Followers (0)
  • Following (0)
All posts
  • All posts (1)
  • Articles (0)
  • Announcements (0)
  • Questions (1)
  • Discussions (0)
Question Freddy Baier · Jan 11, 2023

How to access different columns with the same name in COS?

I have this code:

SELECTid,room,client->name,functionary->nameFROM rooms ORDERBYid

What i do to access the "client" name?

set rs = $SYSTEM.SQL.Execute("SELECT id,room,client->name,functionary->name FROM rooms ORDER BY id")

zw rs.%Get("name")
"return functionary name"
#Caché #Relational Tables #SQL
0 2
0 267
Freddy Baier
@Freddy.Baier
Follow

User statistics

Posts
1
Replies
1
Likes
0
Applications
0
Badges
0
Followers
0
People reached
279
Accepted answers
0
Analytics dashboard
  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2025 InterSystems Corporation, Cambridge, MA. All rights reserved.