The Dates need to be a single field so you would need to add the date fields to the ON clause of your JOIN.
a.stock_rating as rating,
a.rating_date as datefield,
b.trading_quanitity as traded_quantity,
b.price as price
from rating_table a
FULL OUTER JOIN trading_result b ON a.stock = b.stock AND a.rating_date = b.trade_date
use datefield as the X Axis and combine the measures however you like with the Y axis.
Not sure what your data source is (FULL OUTER JOIN isn't available for many connectors) so if you need all the data to come across you might have to get a little creative with the query and standard left joins.
Thanks Aaron, I used Teradata to join the tables. The challenge with the dates is that the rating dates are not equal to the trading dates - I joined the tables on the logic:
Trade_date > last_rating_date and Trade_date <= current_rating_date
So for each two rating dates, I have multiple trades happening in between and the resultant joined table then has the same rating date & rate for that range of trade dates.
I have a near-identical use case, but with Excel datasources. Did you ever find a solution?