This topic is locked

Combining tables in one application

3/13/2017 4:41:18 PM
ASPRunner.NET General questions
S
swiersman author

All,
I have a newbie question;
I have three tables I need to combine for a ASPNETrunner application I am creating.

They each have an "ID" database column which is each tables' primary and is unique within but the same between all tables.

In the QUERY DESIGNER I have created a FULL OUTER JOIN between the TABLE1 and TABLE 2 and TABLE 1 and TABLE 3 referencing each "ID column, and added the columns of TABLES 2 & 3 to the Designer.

I build the project and all fields show and allow entry.

When I go to SUBMIT, It errors out.It says the columns on TABLES 2 & 3 are invalid.

What am doing wrong?
Any help would be greatly appreciated by this newbie with relational databases...
Scott

admin 3/13/2017

Only one database table can be updated at the time. So you need to make sure that you remove fields from joined tables from SQL Query.
This technique is described in this article:

https://xlinesoft.com/asprunnernet/docs/update_multiple_tables.htm