So I am currently working on a site that contains a loan application, in that loan application there is a primary borrower and then there can be up to 2 co-borrowers. What I've done is created a
loanSubmission table that contains a
uid3 column which represents the
user id and then the number of the user. The
id of the user is stored in each one of these columns and the users full information is stored within the
I need to select three users from the data in another table. Is there a way to achieve this using a join or would I have to use sub queries? I've never had to join multiple users based on info from another table so any direction would be greatly appreciated!