How can i merge three table?

[simonegarza]

Hello, i'm looking for a great sql query....look this:
i have this tree tables:

TA
barcode   qnt
1          2
2          3
3          1



TB
barcode   qnt
1          2
2          2
4          1


TC
barcode  desc 
1            abc   
2            def
3            ghi
4            lmn

i need a result like this...do you think it's possible with only one query?

desc  barcode  qntA  qntB
abc    1        2      2
def    2        3      2 
ghi    3        1      -
lmn    4        -      1

[Motoma]

It certainly is possible to do this with one query. Have you tried anything yet? Post what you have done so far, and I will help you through the rest.

[ck9663]

try this one:


select tc.desc, tc.barcode, ta.qnt as qntA, tb.qnt as qntB
from tc
left join ta on tc.barcode = ta.barcode
left join tb on tc.barcode = tb.barcode