Create new columns

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

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. Select FASE.PR_Date_Visita_2, CE.CE_Centro

Re: Some help with a complex query

2003-11-14 Thread Elisenda
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 is that it 's too slow and the result doesn't appear. I am

Re: Some help with a complex query

2003-11-12 Thread Elisenda
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 which tries to select different fields from 5 different tables. In WHERE part I

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