Jill,
>Ellen,
>
>Look in help, but here's a quick example:
>
>Parent table:
> id
> name
>
>Child table:
> id
> date
> event
>
>To show all the events, in order by name and date:
>
>SELECT name, date, event FROM parent, child INTO CURSOR myCursor ORDER BY name, date
How about Join or where? :) What to you want to get by this statement? :)
SELECT name, date, event FROM parent Inner Join child on Parent.id=Child.id INTO CURSOR myCursor ORDER BY 1, 2
>Use myCursor in the report writer. HTH. J
>
>>Thanks for the reply. I guess I don't know how to use SQL Select.
If it's not broken, fix it until it is.
My Blog