I have tried this-
select
Table 1.Product,
Table 1.Currency,
Table 1.Cost,
Case
when Table 2.Currency in ('AUD','CAD','EUR','GBP','INR','PLN','USD')
then (Table 1.Cost/Table 2.ConversionRate) End as Actual Cost
From Table 1, Table 2
but it is giving me 56 records instead...