title: Sql one to many relationship
body: <p>In my application I have the following Clients, Products. I want for each Client to have certain Products( one to many relationship) my code :</p>
  
  <p>Tables Creation :</p>
  
  <pre><code>Create Table Client 
  (
  IDC int identity(1,1) not null primary key,
  NumeC nvarchar(50),
  CIF nvarchar(50) unique
  )
  Create Table Produs
  (
  IDP int identity(1,1) not null,
  NumeP nvarchar(50),
  Cantitate int,
  IDC int 
  )
  </code></pre>
  
  <p>this the Foreign Key :</p>
  
  <pre><code>Alter table Produs add constraint FK_Client_Produs_IDC
  Foreign key (IDC) references Client(IDC)
  </code></pre>
  
  <p>Select statement Query to join Clients and foreach client to show Products :</p>
  
  <pre><code>Select NumeC,CIF from Client
  Inner Join Produs
  ON Client.IDC = Produs.IDC
  </code></pre>
  
  <p>I don't know what am I doing wrong, I just want to show Products for each client. It does not give me that. It just repeats the name of the client, now showing me The products for each client</p>