I'm working on an SQL Query that I'm trying to create a LEFT OUTER JOIN between the Users and UserDefinedData Tables below. The Users Table stores all Users that are registered even if they have not added a record in the UserDefinedData Table. The problem is that once a User adds a "record" in the UserDefinedData Table the User's Username is stored in the FieldValue and not in a Foreign Key Column.

In a relational database, you cannot meaningfully query two tables unless a PK-FK relationship exists between columns in the tables.  So, I think UDT needs to have a FK established before I can pursue creating queries that draw data from both tables. The final SQL Query I'm trying to create would list the username and email address of all users that have not added a record to the UserDefinedData Table.

Not having a PK-FK relationship between the two tables means there is no way to join the two tables together in a relational database, right? Is there a way to connect the User Defined Table to automatically create a new UDT record every time a new user registers?

Any time frame on when the new UDT module will be released that includes limiting the number of records a user is allowed to add?