List:General Discussion« Previous MessageNext Message »
From:Nguyen Manh Cuong Date:July 26 2010 3:49am
Subject:Re: Need Help Writing Simple Query
View as plain text  
Hi Mark,
Please test this query:
select test1.*, (select name from test2 where test2.id=test1.`v_id` limit 1) as name_1, 
(select name from test2 where test2.id=test1.`h_id` limit 1) as name_2 
from test1;

- test1 table:
col1	v_id	h_id
America	1	2

- test2 table: 
id	name
2	SAM
1	UNCLE

----- Original Message -----
From: "Mark Phillips" <mark@stripped>
To: "Mysql List" <mysql@stripped>
Sent: Monday, July 26, 2010 8:29:00 AM
Subject: Need Help Writing Simple Query

I have been away from sql for awhile, and can't seem to figure out how to
write a simple query for two tables.

Table 1 has many columns, two of which are hID and vID. Table 2 has two
columns, ID and name. The hID and vID in table 1 correspond to the IDs in
table 2. I want to make a query so I get all the columns from table 1, but
substitute the names from table 2 for the hID and vID values. For example,

Table 1:
col 1, col 2, hID, vID, col 3
A        B        1     2     C

Table 2:
ID, name
1    fred
2    sam

Query result:
col1, col 2, hName, vName, col 3
A       B        fred      sam       C

Thanks!

Mark

-- 
Best Regards,
Cuongmc.

-- 
Nguyen Manh Cuong
Phong Ky Thuat - Cong ty Vien Thong So - VTC
Dien thoai: 0912051542
Gmail     : philipscuong@stripped
YahooMail : philipscuong@stripped
Thread
Need Help Writing Simple QueryMark Phillips26 Jul
  • Re: Need Help Writing Simple QueryNguyen Manh Cuong26 Jul
    • Re: Need Help Writing Simple QueryMark Phillips26 Jul
  • Re: Need Help Writing Simple QueryJohn List26 Jul