From the first table id i want to retrive the stu_name from
Posted: Tue Jan 18, 2011 5:55 am
Hi,
From the first table id i want to retrive the stu_name from the second table
For Example:
iam having two tables
in table one (stu_id,division,marks) and in table two (stu_id,stu_name). First I want to merge the two tables and then i want to compare the stu_id through i want to retrieve the stu_name from the table two.
i merge the two tables using "join query" but i can't retrieve the stu_name based on the stu_id in the first table
From the first table id i want to retrive the stu_name from the second table
For Example:
iam having two tables
in table one (stu_id,division,marks) and in table two (stu_id,stu_name). First I want to merge the two tables and then i want to compare the stu_id through i want to retrieve the stu_name from the table two.
i merge the two tables using "join query" but i can't retrieve the stu_name based on the stu_id in the first table