Create new columns

2004-03-18 Thread Elisenda
g? If I am wrong what can I do? Thank you in advanced. Elisenda Sala _ SetFile DATABASE FACTORY - Aplicaciones a Medida en FileMaker Pro ( Windows y Macintosh ) <[EM

Re: Some help with a complex query

2003-11-15 Thread Elisenda
Roger, > * Elisenda > [...] >> The explain select says as follows: > [...] > > I re-formatted the query and the EXPLAIN output for readability: Sorry for not re-formatted the query, I've learn it for next time. Well, I've learn a lot with your lessons. &g

Re: Some help with a complex query

2003-11-14 Thread Elisenda
know is that I have 753 records which match FASE.PR_flag=1 and FASE.SQL_ID_PY=P081 and CA.CA_ID_Idioma_A=6 and my result is 253 records. Does it have to be with my query? Or does it have to be with data in mysql, I mean I didn¹t insert them allright? eli > * Elisenda >> The problem

Re: Some help with a complex query

2003-11-12 Thread Elisenda
e.PR_PP_ID_Coord = PP.PP_ID_PP Main relation in all tables is SQL_ID_CE. I don't know if I explain myself or it is too boring to continue reading. It will be fantastic if some can help me. I don't know if I am doing something wrong or what. > * Elisenda >> I have a query whi

Some help with a complex query

2003-11-11 Thread Elisenda
I have a query which tries to select different fields from 5 different tables. In WHERE part I have write all the conditions and relationships. Perhaps two many. The main table for me is FASE. From this table I try to find all the other information. I guess I'm doing something wrong but I d