Forum Discussion
Getting first and second row from related table
I have a related table (1..*) like this: Id Name 1 Foo 2 Bar 3 Blah In my main table, i want to select the first and second "Name" columns, e.g, this would be my main table...
Anonymous , what is a relationship? do you need it one one side or many side ?
as of now it seems like
first name = maxx(filter(Table1, Table[ID]=1), Table[NAme])
Second name = maxx(filter(Table1, Table[ID]=2), Table[NAme])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
The main table is 1, and the table I'm trying to fetch the first and second rows is the "Many".
Table[ID] = 1 won't work, as that'll be the record where ID == 1. I want the "first" record, so i assume there will need to be some TOP/ORDERBY in place?