How to perform data driven load testing for multiple thread

I am in need to simulate a real time scenario of running 50 threads simultaneously where data source has to be shared between running threads. My web service request needs to obtain data from 3 different tables.
Successfully established JDBC connection, I added properties that corresponds to my SQL statement of 1st table, run query & obtained obtain first 10 rows from configured data source

1. Do I need to create 3 different Data source to obtain values from 3 different tables?
2. If so how should I give relation between configured data sources and test request.ie how I should transfer the data from data source to request
3. In data source options “Shared: set to share this data source between running threads during a load test” is one straight forward option for sharing data sources between thread. In my case,I need to fetch values from 3 different tables for my request. How do I accomplish this?

In my case, Will these steps be sufficient to perform a data driven testing
 Configuring JDBC connection,
 Obtaining values from tables
 Transferring data

After this data driven test set up, which load testing strategy will best simulate my scenario of running 50 threads at a time where each thread (at the same point of time)should take different data from the data source.


I would be great if someone could help me resolve this asap.