hi all, i have a major problem in hands, i need to build a query and im hitting walls here, so ill explain the situation:
i have this 4 tables:
now..... i need to make a list of all active workers with their code and position, by this i mean the columns: EMPLEA.nombre EMPLEA.numconemp PUESTO.nombre
the condition is that PLAZAS.fectercon (which is a date field) is higher than the current date, so this would make the worker an active one (this field especifies the expiration date of his/her contract).
as u can see i have to gather fields from 2 diferent tables EMPLEA and PUESTO, but heres the trick, to know PUESTO.nombre i need to first use EMPLEA.numconemp to look for its corresponding code in PLA.clave, then i would look its position name which would be something like PLA.clave = PUESTO.clave and i would then have a fix on PUESTO.nombre
im hitting my head against the wall with this one, im using dbaccess from informix 9.0
any help will be greatly apreciated