I have tray it on different ways to build in the Statements INNER JOIN and OUTER LEFT JOIN, without results.
Following the original SQL CREATE and SELECT orders.
But where comes the JOINT order?
The result now is: Every “Bestelling” has one “Dorpel” and one “Vak”.
But a “Bestelling” can be have more “Dorpels” and a “Dorpel” can be have more “Vak”
[code]SQL =“CREATE TABLE Bestelling (ID INTEGER PRIMARY KEY, KltNum INTEGER”+_
“,PrijsID INTEGER, OrdNumKlt TEXT, User TEXT, OrdNumVT INTEGER,+_
BestDat TEXT, Week INTEGER ,Jaar INTEGER, Status INTEGER+_
, StatDate TEXT,Systeem TEXT, SysMaat INTEGER, Kleur TEXT”+_
“,VspBiBr INTEGER, VspBuBr INTEGER,VspBiDpt INTEGER, +_
VspBuDpt INTEGER, Kop INTEGER, Kap INTEGER, Maat1 INTEGER”+_
“,Maat2 INTEGER, Maat3 INTEGER, Diepte INTEGER, BoorPat TEXT, Notitie TEXT)”
SQL=“CREATE TABLE Dorpel (Bestelling INTEGER, Dorpel INTEGER, Merk TEXT+_
, Aantal INTEGER ,TotL INTEGER, SlA INTEGER, SlB INTEGER, SlType INTEGER+_
, KopLs TEXT, KopRs TEXT, VrMaLs INTEGER, VrMaRs INTEGER+_
, NeuVerLs INTEGER, NeuVerRs INTEGER, AantVak INTEGER, Status INTEGER)”
SQL=“CREATE TABLE Vak(Bestelling INTEGER, Aantal INTEGER, Dorpel INTEGER+_
, Vak INTEGER, NB1 INTEGER, Sponning TEXT, SponNr INTEGER”+_
“, Vsp TEXT, DagMaat INTEGER, Kap TEXT, Letter TEXT, LengteK INTEGER+_
, Strip TEXT, LengteS INTEGER, StatusK INTEGER, StatusS INTEGER, NB2 INTEGER)”
SQL=“SELECT * FROM Bestelling, Dorpel, Vak WHERE Bestelling.OrdNumVT =”+ KlantBox.Cell(SelRow,0)+" AND Bestelling.ID = Dorpel.Bestelling = Vak.Bestelling ;"[/code]