<div>
The solution offered by sedgwick is ok. However, if field THID on Passes1 table can be NULL, then you an consider to change INNER JOIN by LEFT JOIN so you will get any record from Passes1 even if it has no holder associated to it.<br />
<br />
Hope it helps.
</div>


<div>
<div class="content wysiwyg-content">
I need help with an inner join sql statement<br />
Two tables are:<br />
<br />
TABLE: Passes1<br />
PassID<br />
SoldBy<br />
THID<br />
BoxNumber<br />
Year<br />
<br />
TABLE: TicketHolders<br />
HolderID<br />
LName<br />
AllNames<br />
<br />
Here is my SQL <br />
$press_query = &quot;SELECT * FROM Passes1 WHERE Year = '2013' AND THID &lt;&gt;&nbsp;'2059'<br />
<br />
It is displaying like this<br />
Passes1.SoldBy, Passes1.TicketType, Passes1.THID, Passes1.BoxNumber<br />
<br />
I need the Passes1.THID to show the TicketHolders.LName and TicketHolders.AllNames
</div>
</div>


I need help with an inner join sql statement
Two tables are:

TABLE: Passes1
PassID
SoldBy
THID
BoxNumber
Year

TABLE: TicketHolders
HolderID
LName
AllNames

Here is my SQL 
$press_query = "SELECT * FROM Passes1 WHERE Year = '2013' AND THID <> '2059'

It is displaying like this
Passes1.SoldBy, Passes1.TicketType, Passes1.THID, Passes1.BoxNumber

I need the Passes1.THID to show the TicketHolders.LName and TicketHolders.AllNames

The solution offered by sedgwick is ok. However, if field THID on Passes1 table can be NULL, then you an consider to change INNER JOIN by LEFT JOIN so you will get any record from Passes1 even if it has no holder associated to it.

Hope it helps.

Inner Join Question

I need help with an inner join sql statement
Two tables are:

TABLE: Passes1
PassID
SoldBy
THID
BoxNumber
Year

TABLE: TicketHolders
HolderID
LName
AllNames

Here is my SQL 
$press_query = &quot;SELECT * FROM Passes1 WHERE Year = &#39;2013&#39; AND THID &lt;&gt; &#39;2059&#39;

It is displaying like this
Passes1.SoldBy, Passes1.TicketType, Passes1.THID, Passes1.BoxNumber

I need the Passes1.THID to show the TicketHolders.LName and TicketHolders.AllNames

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

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.