<div>
Just itemize the fields you want instead of using A.* and B.*: &nbsp;A.ID, A.firstname ... B.description, B.secondlastname<br />
You do not need to SELECT fields in order to use them in JOIN or WHERE clauses. This will make sure you only get the ID from table A.
</div>


Just itemize the fields you want instead of using A.* and B.*:  A.ID, A.firstname ... B.description, B.secondlastname
You do not need to SELECT fields in order to use them in JOIN or WHERE clauses. This will make sure you only get the ID from table A.

<div>
You can also specify an alias for the field. &nbsp;<br />
<br />

<pre><code id="code-20-39738408-1">Select A.ID as PERSON_ID, B.ID as CONTACT_ID...</code></pre>
</div>


You can also specify an alias for the field.  



Select A.ID as PERSON_ID, B.ID as CONTACT_ID...

<div>
<div class="content wysiwyg-content">
I have 2 tables whit &nbsp;this attributes<br />
&nbsp; &nbsp;TABLE A = person --&gt; id | firstname &nbsp;| lastname &nbsp; &nbsp; | &nbsp; jobtitle<br />
&nbsp; &nbsp;TABLE B = contact--&gt; id | id_person &nbsp;| description &nbsp;| secondlastname<br />
&nbsp;<br />
This is my query in mysql, operating correctly<br />
<br />
$query_services = mysql_query(&quot;SELECT A.*,B.* FROM person A LEFT JOIN contact B ON A.id=B.person_id WHERE $con ORDER BY A.id &quot;);<br />
<br />
while ($row_services = mysql_fetch_array($query_s<wbr />ervices)) {<br />
$id=$row_services['id'];<br />
$nam=$row_services['firstn<wbr />ame'];<br />
$last=$row_services['lastn<wbr />ame'];<br />
$seclast=$row_services['se<wbr />condlastna<wbr />me'];<br />
<br />
MY PROBLEM IS <br />
<b> I WANT TO GET THE 'id' = $id OF TABLE 'person' </b><br />
BUT, I get 'id' the table 'contact'. (I do not want that record)<br />
<br />
should I do?
</div>
</div>


I have 2 tables whit  this attributes
   TABLE A = person --> id | firstname  | lastname     |   jobtitle
   TABLE B = contact--> id | id_person  | description  | secondlastname
 
This is my query in mysql, operating correctly

$query_services = mysql_query("SELECT A.*,B.* FROM person A LEFT JOIN contact B ON A.id=B.person_id WHERE $con ORDER BY A.id ");

while ($row_services = mysql_fetch_array($query_services)) {
$id=$row_services['id'];
$nam=$row_services['firstname'];
$last=$row_services['lastname'];
$seclast=$row_services['secondlastname'];

MY PROBLEM IS 
 I WANT TO GET THE 'id' = $id OF TABLE 'person' 
BUT, I get 'id' the table 'contact'. (I do not want that record)

should I do?

INNER JOIN WITH SAME PRIMARY ID

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.

MySQL Server

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.

Web Servers

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.