sql request different table join

[Anonymous]

Hi 

I ve got 3 different schemas of tables from oracle and I have a sql request to execute that contains left outer join on those tables and I want to write the result of the sql request in a mysql database 

how can I do that ?

what component should I use ?  

pls help 

thank you 

[fdenis]

tOracleInput (insert your join query ) and tMysqlOutput (define your output table).
link them with one row containning one culomn type Dynamic(enterprise) or define all columns (Open)
Regards

[manodwhb]

@trk_54,below way you should design your job.

[Anonymous]

Hi 

thank you for answering

now I got this but I still don't know where should I write my sql querie, which is 

select matcle,nompat, prenom, t1.qualit, t1.corps, t1.catego, t2.indmaj from zy00 t

left outer join zygr t1

on t1.nudoss=t.nudoss and sysdate between t1.dateff and t1.datfin

left outer join zygs t2

on t.nudoss=t2.nudoss and sysdate between t2.dateff and t2.datxxx

where t.socdos='001'

thank you 

[fdenis]

you just nead ZY00 remove ZYGR and ZYGS and TMap1
Select ZY00 click on component Tab add your connection and your SQL query.
on the … add one column using green "+" select dynamic type.

to have help and sample , Select ZY00 and press "F1".

[Anonymous]

I selected ZY00 from the schema of table so there is already a sql query that is written automatically in the query box in component 

[manodwhb]

@trk_54,you can use the below query in single tOracleinput and change the qury by changing to Built in.

select matcle,nompat, prenom, t1.qualit, t1.corps, t1.catego, t2.indmaj from zy00 t

left outer join zygr t1

on t1.nudoss=t.nudoss and sysdate between t1.dateff and t1.datfin

left outer join zygs t2

on t.nudoss=t2.nudoss and sysdate between t2.dateff and t2.datxxx

where t.socdos='001'

[fdenis]

no matter write your!
and modify output schema :
one column type Dynamic( Talend enterprise)
define all columns ( Talend Open)

[Anonymous]

Ok I may be stupid but I still don't understand cause I still got error 

I m going to explain step by step 

First I established a connection to oracle and mysql after that a retrieved schema from oracle and I got those I m interested in (ZY00,ZYGR,ZYGS) 

after that I drag and drop which "component" ? directly ocl0.1 into tOracleInput or I select the retrieved schema ? 

mysql I just a localhost that will contain the result of my query

thank you for according time for my issue

thank you  

[fdenis]

you have already validate your query (with left outer join) so do not rewrite.
1- just drag and drop connection on a tOracle output.
2- copy your query in.
3- create your schema.
4- drag and drop connection on a tmysqlinput and connect.
Done