CODEWITHSUNDEEP
phpmysqlsql
Cihan Aksoy
Cihan Aksoy

Reputation: 15

How to get another table column in my table?

i have two table. Records and Villas

Records table: 

ID, VID (Villa ID), NAME, PRICE

Villas table: 

ID, NAME (Villa NAME), PHOTOS etc.

I using this SQL: 

SELECT records.id, villa_name AS (SELECT name FROM villas WHERE id = records.vid), records.name 
FROM records WHERE records.id = 5

What is wrong ?

Upvotes: 0

Views: 87

Answers (2)

Michael
Michael

Reputation: 12806

Try

SELECT records.id, records.name AS record_name, villas.name AS villa_name FROM records INNER JOIN villas ON records.vid = villas.id WHERE records.id = 5

Edit: Incorporated suggestion from Mark Bannister, below.

Upvotes: 2

Sergio Tulentsev
Sergio Tulentsev

Reputation: 230346

You should use JOIN here.

SELECT r.id, r.name, v.name
FROM records r
INNER JOIN villas v ON v.id = r.vid
WHERE records.id = 5;

Upvotes: 1

Related Questions