Mysql a, b, c three tables left the join-CodePudding

 select a.t tc, convert (a.o ilgunno, SIGNED) as oilgunno, 
A.c ardno, arjun achineoilno, a.o ilno, b.o ilname, 
Y - DATE_FORMAT (a.t akedate, '% % m - H: % d % % I: % s') as takedate 
The from srs_bm_oilvouch a 
LEFT the JOIN srs_system_oiltype b ON a.o ilno=b.o ilno,

And C table also left connection and a table, should how, thank you

CodePudding user response:

Is left connection of the three tables

CodePudding user response:

And left the join b, in the end

CodePudding user response:

In the line, after on the condition to a table with respect to OK

CodePudding user response:

reference 1st floor liuhengwinner response:

is three tables left connection

The select a.t tc, convert (a.o ilgunno, SIGNED) as oilgunno,
A.c ardno, arjun achineoilno, a.o ilno, b.o ilname,
Y - DATE_FORMAT (a.t akedate, '% % m - H: % d % % I: % s') as takedate
The from srs_bm_oilvouch a
LEFT the JOIN srs_system_oiltype b ON a.o ilno=b.o ilno
LEFT the JOIN table C C ON a.X=c.X XX XX

CodePudding user response:

 LEFT JOIN C ON C.o ilno=A.o ilno

CodePudding user response:

 select a.t tc, convert (a.o ilgunno, SIGNED) as oilgunno, 
A.c ardno, arjun achineoilno, a.o ilno, b.o ilname, 
Y - DATE_FORMAT (a.t akedate, '% % m - H: % d % % I: % s') as takedate 
The from srs_bm_oilvouch a 
LEFT the JOIN srs_system_oiltype b ON a.o ilno=b.o ilno, 
LEFT the JOIN the third table c ON a.o ilno=c.o ilno

CodePudding user response: