Analytics Software

Hi

I want to know , is there any relationship exists between snp_lpi_step & snp_session table.

select

d1.load_plan_name,  d2.start_date,  d2.end_date,  d2.duration, d2.status,

d2.nb_run, d3.i_lp_step, d3.lp_step_name, d3.lp_step_type

from snp_lp_inst d1,

     snp_lpi_run d2,

     snp_lpi_step d3

where   d1.i_lp_inst=d2.i_lp_inst

and d2.i_lp_inst=d3.i_lp_inst

and d1.i_lp_inst='30500'

and d2.nb_run=2

order by d1.i_lp_inst,d3.i_lp_step;

I want to join snp_session table now on the above sql, how can i do it, any idea..

Thanks