> "M. A. Alves" wrote:
>
> > I think the problem is in your query expression.
you're absolutely right here
> I have reformulated your
> > original query using my style and that consistently results in 4 rows
> > which I think is what you wanted.
> >
> > Original_Query : String :=
> > "select distinct Exhibition.InternalNumber,Exhibition.Name,"&
> > "Exhibition.Openning,Exhibition.Closure,Exhibition.Schedule,"&
> > "Country.Name,City.Name,ExhibitionHall.Name,Exhibition.AdressPhones,"&
> >
> > "Exhibition.ExhibitionURL,Exhibition.Organizer,Exhibition.OrganizerPhoneFax,"&
> > "Exhibition.OrganizerURL,Exhibition.Logo,Exhibition.Description from "&
> > "ExhibitionTopic left join Exhibition on ExhibitionTopic.Exhibition="&
> > "Exhibition.InternalNumber left join ExhibitionHall on
> > Exhibition.Hall="&
> > "Exhibition.InternalNumber left join City on
that is mistake here must be ExhibitionHall.InternalNumber - I just can't get how
did I manage to miss this typo for so long :0(
Thanks everybody for helping me
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
