Jump to content

Archived

This topic is now archived and is closed to further replies.

chiba

Help writing an Oracle script to join three tabels

Recommended Posts

I am new to Oracle and need to write a script to extract data from three tables.

 

The code below works and produces results. For every transaction in the  transaction_table it produces a row with the customers details.

select
u.account_id,
u.currency_code,
u.country_of_residence_name,
t.bet_desc,
t.event_name,
t.amount,
t.settled_dt,
t.acc_stat_summ_id

from transaction_table t

inner join customer_details u
on t.account_id = u.account_id

where u.country_of_residence_name = 'Canada'
and t.bet_desc = 'Withdrawal'
and t.event_name = 'Bank Transfer'
and t.settled_dt> '01 Aug 2012'

 

But I need to link it to a further table , how can this be done? I tried he following but got no results.

select
u.account_id,
u.currency_code,
u.country_of_residence_name,
t.bet_desc,
t.event_name,
t.amount,
t.settled_dt,
t.acc_stat_summ_id

from transaction_table t

inner join customer_details u
on t.account_id = u.account_id


inner join bank_transfers b
on t.acc_stat_summ_id = b.bank_transfer_id

where u.country_of_residence_name = 'Canada'
and t.bet_desc = 'Withdrawal'
and t.event_name = 'Bank Transfer'
and t.settled_dt> '01 Aug 2012'

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.