<div>
I know I can do CONCAT(firstName, ' ', lastName) AS fullName.<br />
<br />
How do I do this with two userID's in a joined query?
</div>


I know I can do CONCAT(firstName, ' ', lastName) AS fullName.

How do I do this with two userID's in a joined query?

<div>
Try:<br />

<pre><code id="code-20-40914788-1">SELECT CONCAT(B.firstName, B.lastName) as senderName, (SELECT CONCAT(firstName,' ', lastName) FROM `leads_userInfo` WHERE `userID`=A.recipientID LIMIT 1) as recipientName, A.`subject`, A.`status`, A.`dateCreated` as `date`
FROM simpleNote as A 
INNER JOIN leads_userInfo as B
ON A.senderID=B.userID</code></pre>
</div>


Try:


SELECT CONCAT(B.firstName, B.lastName) as senderName, (SELECT CONCAT(firstName,' ', lastName) FROM `leads_userInfo` WHERE `userID`=A.recipientID LIMIT 1) as recipientName, A.`subject`, A.`status`, A.`dateCreated` as `date`
FROM simpleNote as A 
INNER JOIN leads_userInfo as B
ON A.senderID=B.userID

<div>
hielo This is so close! If the query was based on a record where simpleNote id =1 how &nbsp;would this look?
</div>


hielo This is so close! If the query was based on a record where simpleNote id =1 how  would this look?

<div>
<div class="content wysiwyg-content">
Hello I need to query a table. I have to get two users names but I have the ID's from the lead_users table ..<br />
I want to show each as their full name {first Last) <br />
<br />
((Message table)) table name = simpleNote<br />
id<br />
senderID<br />
recipientID<br />
subject<br />
message<br />
status<br />
dateCreateated &nbsp;&lt;-- MySQL Timestamp<br />
<br />
((User table)) table name = leads_userInfo<br />
userID<br />
firstName<br />
LastName<br />
<br />
<br />
<br />
So I want to get a row that is like this:<br />
<br />
FirstName LastName subject status date <br />
Order by date<br />
<br />
I want to do this with PHP PDO
</div>
</div>


Hello I need to query a table. I have to get two users names but I have the ID's from the lead_users table ..
I want to show each as their full name {first Last) 

((Message table)) table name = simpleNote
id
senderID
recipientID
subject
message
status
dateCreateated  <-- MySQL Timestamp

((User table)) table name = leads_userInfo
userID
firstName
LastName



So I want to get a row that is like this:

FirstName LastName subject status date 
Order by date

I want to do this with PHP PDO

Help with Join

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.

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.