U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » Developing U++ » U++ Developers corner » Add columns to SqlArray from database table by foreign key

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Add columns to SqlArray from database table by foreign key [message #59045]

Thu, 20 October 2022 11:56

dinamon
Messages: 3
Registered: October 2022
Location: Ru

Junior Member

Good afternoon!
I can't figure out how to add a column from a database table. For example , we have tables:

TABLE_(table1)
SERIAL_ (tb1_id)
STRING_ (name)
STRING_ (last_name)
END_TABLE
TABLE_(table2)
SERIAL_ (tb2_id)
INT_ (tb2_tb1_id) REFERENCES(table1)
STRING_ (book)
STRING_ (description)
END_TABLE

And I need to display the table:
-------------------------------------
|book | description| name| last_name|
-------------------------------------

Report message to a moderator