<div>
try this<br />

<pre><code id="code-8088269">select * from eeconf
left outer join eereminders
on eeconf.code = eereminders.code</code></pre>
</div>


<div>
Thanks all! &nbsp;Sharath and pratima worked properly so I split the points!<br />
<br />
Thanks!!
</div>


<div>
<div class="content wysiwyg-content">
Hi - I have 2 tables eeconf and eereminders. &nbsp;I want to display everything * from eeconf but I want to count how many appearances of the column `code` that appears in eereminders. &nbsp; I'm not sure how the join would look. &nbsp;`code` is common to eeconf and eereminders. &nbsp;I want to display every record from eeconf even if there isn't a `code` match in eereminders.<br />
<br />
Hope I was clear enough! :)<br />
<br />
Thanks - Zack
</div>
</div>


Hi - I have 2 tables eeconf and eereminders.  I want to display everything * from eeconf but I want to count how many appearances of the column `code` that appears in eereminders.   I'm not sure how the join would look.  `code` is common to eeconf and eereminders.  I want to display every record from eeconf even if there isn't a `code` match in eereminders.

Hope I was clear enough! :)

Thanks - Zack

Thanks all!  Sharath and pratima worked properly so I split the points!

Thanks!!

MYSQL Join Help

Hi - I have 2 tables eeconf and eereminders.  I want to display everything * from eeconf but I want to count how many appearances of the column `code` that appears in eereminders.   I&#39;m not sure how the join would look.  `code` is common to eeconf and eereminders.  I want to display every record from eeconf even if there isn&#39;t a `code` match in eereminders.

Hope I was clear enough! :)

Thanks - Zack

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.