Hi Helen

Thanks for responding.

At 08:50 pm 09/08/2004, you wrote:

>The semicolons scattered around your query are illegal

Actually this was the VFP SQL I had pasted, sorry about not clarifying.

>and you need full
>aliasing for *each* usage of the table, i.e. you can't use the plain table
>identifier for one instance and an alias for the other.

Okay I will keep that in mind. But just for my knowledge, has the thing
become more strict than it was in 1.5.0?

>SELECT
> child.*,
> parent.CNAME AS CGROUPNAME
>FROM MPLANTS child
> LEFT JOIN MPLANTS parent
> ON child.IID = parent.IPID
> ORDER BY child.CCODE, child.CNAME

Thanks that worked perfectly. I had panicked when I had to use RIGHT JOIN
to get results.

Thanks a lot for your help.




Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
namitbn@...
___________________________________________

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.735 / Virus Database: 489 - Release Date: 06/08/2004


[Non-text portions of this message have been removed]