Hi.. I need a query to select data from two tables and set the value of a column based on the data on table 2. example: Table 1 contain student name and ID. Table 2 contain ID and grade.
result should contain, the ID, name ( selected from table 1 based on the ID) and grade.
Thank You Webfred.. :) Example was just a Sample But i want the name to be selected based on the ID. Which means if the ID is '70', the query should search it from Table 1.
Select Data based on Another Table
Posted - 04/10/2012 : 04:35:04
