Hi
Try this code
--Create Table MaleTable
--Create Table FemaleTable
--(
--Id int primary key identity(1,1),
--Name varchar(40),
--age int
--)
--Insert into MaleTable values('aaa',20)
--Insert into MaleTable values('bbb',30)
--Insert into MaleTable values('ccc',23)
--Insert into FemaleTable values('sss',78)
--Insert into FemaleTable values('fff',32)
--Insert into FemaleTable values('ggg',14)
Answer is
============
Select name,age from MaleTable where age=(Select min(age) from MaleTable) --20
Select name,age from FemaleTable where age=(Select min(age) from FemaleTable) --14
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com
Mandlaa, if this helps please login to Mark As Answer. | Alert Moderator