Hi everyone, i have a different scenario for getting data with calculation. I have two table in the database that one is station, the other is data. I want to get only sum of root station. However, the users can insert data only child station. How do i do this? I added a picture demostrate the situation.

I'm not sure what you want or what's the problem.

So would you please exaplain it in more details and step by step, mabe by posting code snippets of what you have tried.

I have a table that include the station information. I have a table that include the data of the station.

Stations are two type; parent and child. There are a self-relation on the table.

I want to get data from table, but i want to calculate value from child datas and display this data on the parent station like parent station data.

I hope this is clear. I added a picture for station, data tables and wanted result table. You can see it as attachment.

what I understand is that you want to display fields of root/parent stations. With aggregated data of child stations.

Could you please post the SQL query of what you need to disaplay, and then we can work it out wih LLBLGen code.