awk cmd for vlookup in Mysql

Shell Programming and Scripting
1

Hi,

Is there possible to do vlookup in Mysql one table from another table based on one column values and placed the data in same table?

if it is possible in mysql itself pls share links for reference.
Here is the ex: i need to vlookup the cus.id in table to and place the cus.name in 4th column of table 1.
Table 1

Count	date	Cus.id
20	8012015	104.3
25	9012015	104.5
40	9012015	104.3

Cus.id	Cus.name
104.3	Math
104.5	Visy
104.3	Math

Thanks..

2

Assuming you are talking of the EXCEL vlookup function, isn't that a crude approximation of the standard sql select statement?

3

i've enter example. i can use excel but its huge data so i can't work in excel...

4

You'll either have to alter the table by adding another column or you could create a view on both tables.