StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>The problem is in my select statement:</p> <pre><code>SELECT Kolonminhas.KolonminhaID ,Kolonminhas.KolonID AS [Kolonminhas KolonID] ,Kolonminhas.Aciklama ,Kolonminhas.En AS [Kolonminhas En] ,Kolonminhas.Boy AS [Kolonminhas Boy] ,Kats.KatID AS [Kats KatID] ,Kats.BlokID AS [Kats BlokID] ,Kats.Ad AS [Kats Ad] ,Kats.Kolonaltkot ,Kats.Kolonustkot ,Bloks.BlokID AS [Bloks BlokID] ,Bloks.ProjectID ,Bloks.Ad AS [Bloks Ad] ,Kolons.KolonID AS [Kolons KolonID] ,Kolons.KatID AS [Kolons KatID] ,Kolons.KolonAdi ,Kolons.En AS [Kolons En] ,Kolons.Boy AS [Kolons Boy] ,Kolons.Yukseklik ,Kolons.Altkot ,Kolons.UstKot FROM Kolons INNER JOIN Kolonminhas ON Kolons.KolonID = Kolonminhas.KolonID INNER JOIN Kats ON Kolons.KatID = Kats.KatID INNER JOIN Bloks ON Kats.BlokID = Bloks.BlokID </code></pre> <p>To solve this issue OUTER JOIN command should be used. However I am not able to create one. I would appreciate it if someone help me.</p> <p>And this is the correct query:</p> <pre><code>SELECT Kolonminhas.KolonminhaID ,Kolonminhas.KolonID AS [Kolonminhas KolonID] ,Kolonminhas.Aciklama ,Kolonminhas.En AS [Kolonminhas En] ,Kolonminhas.Boy AS [Kolonminhas Boy] ,Kats.KatID AS [Kats KatID] ,Kats.BlokID AS [Kats BlokID] ,Kats.Ad AS [Kats Ad] ,Kats.Kolonaltkot ,Kats.Kolonustkot ,Bloks.BlokID AS [Bloks BlokID] ,Bloks.ProjectID ,Bloks.Ad AS [Bloks Ad] ,Kolons.KolonID AS [Kolons KolonID] ,Kolons.KatID AS [Kolons KatID] ,Kolons.KolonAdi ,Kolons.En AS [Kolons En] ,Kolons.Boy AS [Kolons Boy] ,Kolons.Yukseklik ,Kolons.Altkot ,Kolons.UstKot from Bloks left join (Kats left join (Kolons left join Kolonminhas on Kolons.KolonID = Kolonminhas.KolonID) ON Kats.KatID = Kolons.KatID) ON Bloks.BlokID = Kats.BlokID </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload