but through SQL query views can be found out data, what is this problem!! How to solve? SELECT DISTINCT
Be sad oodsSpec chtistina georgina rossetti.british poetess be sad oodsName chtistina georgina rossetti.british poetess c.G oodsCode,,, c.P lace, c. anufacturer, qq, STAFFNAME, b.u nit, a. illNo, a. illSn, a. illSort, al-qeada oodsId, Amy polumbo ackId, t1. The BatchCode,
T1 ProduceDate, t1 ValDate, CASE WHEN o.r fruleid="' THEN 0 ELSE a.N um END AS num, y.D ates AS outbound date, q.D ates AS single date of make out an invoice,
Yy. Cost * a.N um AS costamt, a.A mount - yy. Cost * a.N um AS profit, Amy polumbo rice, a.A mount, a.R ate, a.T axprice, a.T axAmount, a.T ax, h.B illCode, h.D ates, o.R fBillCode,
Y.R fBillCode AS billing list
The FROM dbo. INVOICEDT AS a INNER JOIN
Dbo. INVOICEBILL AS o ON a. illNo=onychoteuthis illNo AND a.R fBillNo=o.R fBillNo AND a.E ntId=o.E ntId LEFT OUTER JOIN
Dbo. SALEOUTMT AS y ON o.R fBillCode=y.B illCode AND a.E ntId=y.E ntId LEFT OUTER JOIN
Dbo. SALEOUTDT AS yy ON yy. BillNo=y.B illNo AND a.E ntId=yy, EntId AND al-qeada oodsId=yy. GoodsId AND a.R fBillSn=yy. BillSn LEFT OUTER JOIN
Dbo. SALENOTESMT AS q ON y.R fBillCode=q.B illCode AND a.E ntId=q.E ntId LEFT OUTER JOIN
Dbo. STAFFDOC AS qq ON y.S aleManId=qq. STAFFID AND y.E ntId.=qq ENTID LEFT OUTER JOIN
Dbo. PGPRICE AS b ON yy. GoodsId=b.G oodsId AND yy. PackId=p. ackId AND a.E ntId=b.E ntId INNER JOIN
Dbo. GOODSDOC AS c ON yy. Be sad oodsId chtistina georgina rossetti.british poetess GoodsId=AND a.E ntId=c.E ntId LEFT OUTER JOIN
Dbo. INVOICEMT AS h ON a. illNo=h.B illNo AND a.E ntId=h.E ntId INNER JOIN
ID=dbo.ORG DOC AS d ON d.ORG h.Org ID AND d.E NTID=h.E NTID LEFT OUTER JOIN
Dbo. DEPTDOC AS f ON h.D eptId=f.D eptId AND h.E ntId=f.E ntId LEFT OUTER JOIN
Dbo. STAFFDOC AS g ON h.c aozy=g.S TAFFID AND h.E ntId=g.E ntId INNER JOIN
Dbo. BUSINESSDOC AS n ON practice fId=n.B usinessId AND h.E ntId=n.E ntId LEFT OUTER JOIN
Dbo. BATCHCODE AS t1 ON yy. AngleId=t1. AngleId AND yy, GoodsId=t1. GoodsId AND yy. EntId=t1. EntId
CodePudding user response:
Under the guidance of leaders?????
CodePudding user response:
Which kind of bosses look???CodePudding user response:
Don't literally what kind of design, it's not professional, create and modify the view, language sentence to complete: