how can compare two columns in different table

baskaran chellasamy

13y2.5k

Hello friends, I have two table. 1. StudentAdmissiondetails column: AdmissionNumber and extra 2. StudentAcadmicdetails cloumn: AdmissionNumber and extra. I want to compare two AdmissionNumber column and if AdmisssionNumber in table 1 and not in table 2 mean I want to some task. this task i can do it. two tables may contain many sdmissionNumber. how can i do it.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sivaraman Dhamodaran13y ago
Try this:

Select StudentAdmissiondetails.AdmissionNumber from StudentAdmissiondetails Where Not Exists ( Select StudentAcadmicdetails.AdmissionNumber from StudentAcadmicdetails
where StudentAcadmicdetails.AdmissionNumber = StudentAdmissiondetails.AdmissionNumber)
baskaran chellasamy13y ago
this is my query for getting AdmissionNumber studentName and ClassName.

ALTER procedure [dbo].[sp_getstudentList](@classid int,@fromyear smallint,@toyear smallint) as
begin
declare @acid int,@admissionnumber int,@admissionnumber1 int
select @acid=Acadamic_year_id from School.dbo.Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear
select sa.AdmissionNumber,sa.StudentName,st.Standered_name from School.dbo.StudentAdmission_details sa inner join School.dbo.Standered_details st on sa.ClassId=st.Standered_id where sa.ClassId=@classid and sa.Academic_year_id=@acid
end

If admissionnumber not exists in studentAcademictable then i want to use the join query.how can do it
Shankar M13y ago
Hi Baskar,

Here it is, You can get it through the correlated subquery.

Something like this,

SELECT *
FROM StudentAdmissiondetails a
WHERE NOT EXISTS (SELECT 'Y'
FROM StudentAcadmicdetails b
WHERE b.AdmissionNumber=a.AdmissionNumber);

Which will get you all the Admission number that are not in Table B that is your
StudentAcadmicdetails.

Thanks,
Shankar