[EMAIL PROTECTED] (--CELKO--) wrote in message news:<[EMAIL PROTECTED]>... > Please write DDL and not narrative. here is my guess at what you are > trying to do. What you posted was not a table because you had no key. > TEXT is not the datatype to use for names -- unless they are thousand > of characters long!! > Recording age as an integer is useless -- give us the birthday and we > can always compute their age. Is this what you meant to post? >
I didnt give DDL because was to abstract to explain, this is just an example, i did translate the query (really was a subquery in a IN ) and it work... dont care about the data types, I was interest only in the relations.... ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]