Databases
StackOverflow2013
Postsdbo
POSQL SERVER - populate bridge table but eliminate some data
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL SERVER - populate bridge table but eliminate some data
    text
    copied!<pre><code>SELECT C.CarID, C.Make, Y.Year, M.Model , e.Engine FROM Car C INNER JOIN CarYear CY ON CY.CarID = C.CarID INNER JOIN Year y ON y.YearID = CY.YearID INNER JOIN Model m ON m.CarID = C.CarID INNER JOIN Engine e ON e.ModelId = m.ModelID </code></pre> <p>I am new to SQL SERVER and please tell me how to solve this problem. I separate all tables, Car, Year, Model, Engine. I populate bridge table dbo.CarYear &amp; dbo.ModelYear with cross join and now I have this query and result is:</p> <pre><code>1 Acura 1999 ILX 1.5 L LR ELECT/GAS 1 Acura 1999 ILX 2.0 L L4 SOHC 1 Acura 1999 ILX 2.4 L L4 DOHC 1 Acura 1999 RDX 3.5 L V6 1 Acura 1999 RLX 3.5 L V6 1 Acura 1999 MDX 3.7 L V6 1 Acura 2000 ILX 1.5 L LR ELECT/GAS 1 Acura 2000 ILX 2.0 L L4 SOHC 1 Acura 2000 ILX 2.4 L L4 DOHC 1 Acura 2000 RDX 3.5 L V6 1 Acura 2000 RLX 3.5 L V6 1 Acura 2000 MDX 3.7 L V6 1 Acura 2001 ILX 1.5 L LR ELECT/GAS 1 Acura 2001 ILX 2.0 L L4 SOHC 1 Acura 2001 ILX 2.4 L L4 DOHC 1 Acura 2001 RDX 3.5 L V6 1 Acura 2001 RLX 3.5 L V6 1 Acura 2001 MDX 3.7 L V6 1 Acura 2002 ILX 1.5 L LR ELECT/GAS 1 Acura 2002 ILX 2.0 L L4 SOHC 1 Acura 2002 ILX 2.4 L L4 DOHC 1 Acura 2002 RDX 3.5 L V6 1 Acura 2002 RLX 3.5 L V6 1 Acura 2002 MDX 3.7 L V6 1 Acura 2003 ILX 1.5 L LR ELECT/GAS 1 Acura 2012 ILX 1.5 L LR ELECT/GAS 1 Acura 2012 ILX 2.0 L L4 SOHC 1 Acura 2012 ILX 2.4 L L4 DOHC 1 Acura 2012 RDX 3.5 L V6 1 Acura 2012 RLX 3.5 L V6 1 Acura 2012 MDX 3.7 L V6 1 Acura 2013 ILX 1.5 L LR ELECT/GAS 1 Acura 2013 ILX 2.0 L L4 SOHC 1 Acura 2013 ILX 2.4 L L4 DOHC 1 Acura 2013 RDX 3.5 L V6 1 Acura 2013 RLX 3.5 L V6 1 Acura 2013 MDX 3.7 L V6 </code></pre> <p>as you can see, all Acura at any Year has the same models for example, how can I eliminate some of the Car models before I populate bridge table ,(for example Acura ILX started only from 2013) </p>
 

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