Relations / Joins

Hello,

i have 2 tables that basically share information.

Table 1 Layout: EID, v1, v2, v3

Table 2 Layout EID, FirstName, LastName, MiddleName

what i need to do, is select the first, middle and last name from Table 2, using EID from table 1.

in SQL Server i would just do

select t1.EID, t1.v1, t1.v2, t2.First, t2.Middle, t3.Last
from table1 t1
inner join table2 t2 on t1.eid = t2.eid

how would i accomplish the same in backendless?

Note: im using the .net SDK.

Hi James,

Backendless uses an object model, which is pretty different from the one SQL uses. You can use relations and queries in Backendless to accomplish what you want. Please read about the data service in the documentation, it also has paragraphs on relations.

Also, note that designing and writing your application for you is not a free option, according to our Support Policy.