adding the table for time column i want only day hour and minutes how to declare that in sql table.

it is displaying as zero records

table 1@sampledata

id=1,age=18,gender=male

table2@sample data

id=1,maturnity=child,gender=male

id=2,maturnity=adult,gender=female

id=2,maturnity=child,gender=female

id=2,maturnity=adult,gender=male

this is the sample data

while getting the data we will compare

where table2.gender=table1.gender

and table1.id=1

in the same way i should compare age also

it is correct but while getting the data from data base according to the id from the first table if the age is less than 18 we should get child...

i cant understand what u are saying

table1 table2

id id

age...

please anyone help me yar how to declare a variable for comparing ages...:-)