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