I have two tables in the same SQL database that I want to pull information from (and have a user id in a hidden form field) so that when my writers submit documents through my admin system, it gets automatically tagged in the documents table with their user id.
Would that be creating a 'union' or is it something else?
Database Name
Table 1 - User Registration - I want to pull registered user ID from here.
Table 2 - Document Uploads - And attach it to the form upload when this is submitted.
Also, if it is a union, am I able to put an array on a page that will pull fields from both tables or just one?
TIA for any feedback
