<div>
SELECT customers .* <br />
FROM customers <br />
LEFT JOIN orders ON customers.customers_id= orders.customers_id<br />
WHERE customers.dealer = 1
</div>


<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
i have a customers table and an orders table in my client's database...<br />
<br />
in the customers table there is a boolean value for &quot;dealer&quot; (ie whether they're are a dealer or not)<br />
<br />
in the orders table there is &quot;customers_id&quot; column for the id number of the customer (funnily enough :))<br />
<br />
now, my client want a list of all dealers who signed up within a certain period but haven't placed an order...<br />
<br />
could someone help me with the SQL to produce this list<br />
<br />
many thanks in advance for any help
</div>
</div>


hi,

i have a customers table and an orders table in my client's database...

in the customers table there is a boolean value for "dealer" (ie whether they're are a dealer or not)

in the orders table there is "customers_id" column for the id number of the customer (funnily enough :))

now, my client want a list of all dealers who signed up within a certain period but haven't placed an order...

could someone help me with the SQL to produce this list

many thanks in advance for any help

SELECT customers .* 
FROM customers 
LEFT JOIN orders ON customers.customers_id= orders.customers_id
WHERE customers.dealer = 1

A simple SQL exclusion question

hi,

i have a customers table and an orders table in my client&#39;s database...

in the customers table there is a boolean value for &quot;dealer&quot; (ie whether they&#39;re are a dealer or not)

in the orders table there is &quot;customers_id&quot; column for the id number of the customer (funnily enough :))

now, my client want a list of all dealers who signed up within a certain period but haven&#39;t placed an order...

could someone help me with the SQL to produce this list

many thanks in advance for any help

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.