<div>
Select * from Clients left join Invoices on<br />
Clients.ClientID = Invoice.ClientID <br />
where Invoices.ClientID is null
</div>


<div>
I realize you're new Patrice so I hope that I don't sound too harsh. When someone posts a comment in this group (and not all of the groups work the same way, you're just going to have to learn which ones do/don't over time), you should also post a comment. You then leave it up to the person who posed the &nbsp;question to decide which answer best suits his/her needs.<br />
<br />
As it stands now, because you &quot;answered&quot; the question, you will default to getting the points if the person that answered the question does not accept your answer after a certain period of time.<br />
<br />
Welcome to Expert Exchange, BTW.
</div>


<div>
Sorry, this is my answer as a comment...<br />
Select * from Clients left join Invoices on <br />
Clients.ClientID = Invoice.ClientID <br />
where Invoices.ClientID is null<br />

</div>


<div>
<div class="content wysiwyg-content">
Hello<br />
I have two tables related by common field.<br />
1ª table-Clients<br />
2º table-invoices<br />
common field-&gt;clientID<br />
In SQL, how can I retrieve clients from the first table that have not invoices in the second table.<br />
I'm working with VB 6.0<br />
<br />
Thanks
</div>
</div>


Hello
I have two tables related by common field.
1ª table-Clients
2º table-invoices
common field->clientID
In SQL, how can I retrieve clients from the first table that have not invoices in the second table.
I'm working with VB 6.0

Thanks

Select * from Clients left join Invoices on
Clients.ClientID = Invoice.ClientID 
where Invoices.ClientID is null

I realize you&#39;re new Patrice so I hope that I don&#39;t sound too harsh. When someone posts a comment in this group (and not all of the groups work the same way, you&#39;re just going to have to learn which ones do/don&#39;t over time), you should also post a comment. You then leave it up to the person who posed the  question to decide which answer best suits his/her needs.

As it stands now, because you &quot;answered&quot; the question, you will default to getting the points if the person that answered the question does not accept your answer after a certain period of time.

Welcome to Expert Exchange, BTW.

Sorry, this is my answer as a comment...
Select * from Clients left join Invoices on 
Clients.ClientID = Invoice.ClientID 
where Invoices.ClientID is null


SQL to retrieve data

Hello
I have two tables related by common field.
1ª table-Clients
2º table-invoices
common field-&gt;clientID
In SQL, how can I retrieve clients from the first table that have not invoices in the second table.
I&#39;m working with VB 6.0

Thanks

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.