I wrote a relational query, associated conditions can use different table field to associate, strives for the great god answer
The SELECT a.S HOPID
, b.G OODSID
NVL (c.Q TY, 0) as startqty
The FROM FR_WHOLESALE a

LEFT the JOIN FR_WHOLESALEITEM b ON
A.S HEETID=b.S HEETID
LEFT the JOIN FR_SHOPSTOCKDAILY c ON
Be sad OODSID chtistina georgina rossetti.british poetess b.G OODSID=and a.S HOPID c.s. HOPID=

CodePudding user response:

What did you write this statement is submitted to the wrong?