Left Join and Like command used together

[Daniel Peter]

How can i use Left Join in an SQL as well as use Like command in the same sql statement. And can you please give me various examples of the codes i can use as well as the table generated from the SQL statement.

[Atli]

Hi, and welcome to TSDN.

Do you mean something like this?

SELECT
  CONCAT(
    tUser.LastName, 
    ',', 
    tUser.FirstName
  ) AS 'Name',
  CONCAT(
    tAddress.StreetName, ' ',
    tAddress.StreetNumber, ', ',
    tAddress.CityName 
  ) AS 'Address'
FROM userTable AS tUser
LEFT JOIN addressTable AS tAddress
  ON tAddress.userID = tUser.userID
WHERE tUser.LastName
  LIKE '%an%'
AND tAddress.Country
  LIKE '%america%'
ORDER BY
  tUser.LastName
 

Which might generate something like this:

Name              Address
------------------------------------------
Anderson, Pamela  Someroad 6, Los Angeles
Cartman, Eric     Street 666, South Park