Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
Developer Community
  • Posts
    • InterSystems Official
    • Articles
    • Questions
    • Announcements
    • Discussions
    • Tags
  • Events
    • Tech Article Contest
    • Programming Contest
    • InterSystems Ideas Contest
    • Event Calendar
  • 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

EN

Search by posts, members, tags
Language
EN|
ESPTJPCNFREN
New post
  • Profile page
  • Posts (1)
  • Replies (1)
  • Mentions (1)
  • Official certification & Credly badges (0)
  • Global Masters badges (3)
  • 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:

SELECT id,room,client->name,functionary->name FROM rooms ORDER BY id

What i do to access the "client" name?

#Relational Tables #SQL #Caché
0 2
0 264
Freddy Baier
@Freddy.Baier
Follow
Open Exchange profile

User statistics

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

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up