<div>
Perfect. Thank you so much for your help and quick reply.
</div>


Perfect. Thank you so much for your help and quick reply.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm using sqlite. I have 2 tables. One is a detail table. I want to select all the records in table 1 only if they have details in table 2 where the column &quot;type&quot; equals &quot;List&quot;<br />
<br />
select * from Vehicles<br />
<br />
having<br />
<br />
select count &gt;&nbsp;0 from list_detail where type = &quot;List&quot;<br />
<br />
Any help would be greatly appreciated.<br />
<br />
-S
</div>
</div>


Hi,

I'm using sqlite. I have 2 tables. One is a detail table. I want to select all the records in table 1 only if they have details in table 2 where the column "type" equals "List"

select * from Vehicles

having

select count > 0 from list_detail where type = "List"

Any help would be greatly appreciated.

-S

Select only if count results type &gt; 0 in detail table

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

Select only if count results type &gt; 0 in detail table

Select only if count results type > 0 in detail table