;
- test1 table:
col1v_idh_id
America 1 2
- test2 table:
id name
2 SAM
1 UNCLE
- Original Message -
From: Mark Phillips m...@phillipsmarketing.biz
To: Mysql List mysql@lists.mysql.com
Sent: Monday, July 26, 2010 8:29:00 AM
Subject: Need Help Writing
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
SAM
1 UNCLE
- Original Message -
From: Mark Phillips m...@phillipsmarketing.biz
To: Mysql List mysql@lists.mysql.com
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
On 07/25/2010 09:29 PM, Mark Phillips wrote:
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