querying table?

[yenron]

Hello there,
I am querying table A for all employee numbers where the employee gender = m, next i want to query table B for all info where the employee numbers = the employee numbers from the first query. How is that pulled off?
Thank you so much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

Try to do the following:
select A.enum, B.* from A, B where A.egen='m' and B.enum=A.enum; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --