0

Select from two tables

Hey there ,

I'm new to the Ninox and i'm having realy hard time doing one simple select. 

I have 2 tables Books and Legacy Books . I need to select field from Legacy Books named "Titre" where id is the same as in Books table.

How should i do that ?

I tried something like that :

let i := (select 'Legacy Books').'No Ordre 2';
let j := (select BOOKS).'B-ID';
let w := (select 'Legacy Books' where i = j);
w.Titre

2 replies

null
    • Kim_Tischler
    • 4 yrs ago
    • Reported - view

    let book := (select BOOKS)['B-ID' = 123]

    let titre := (select 'Legacy Books')[id = book.id].Titre

    • Piotr_Wareciak
    • 4 yrs ago
    • Reported - view

    Is there a way to take the variable 'B-ID' more dynamically?

Login to reply

Content aside

Categories

View all topics
  • 4 yrs agoLast active
  • 2Replies
  • 485Views