>>The following query runs properly in 2.6
>>SELECT imgidf.filename, dataf.frame_id, dataf.stud_id, dataf.ssn,;
>>dataf.f_name, dataf.l_name, dataf.m_initial, dataf.address,;
>>dataf.city, dataf.state, dataf.zip, dataf.phone, dataf.prnt_name,;
>>dataf.prnt_phone, dataf.emer_name, dataf.emer_phone,;
>>dataf.tchr_name, dataf.homeroom, dataf.grade, dataf.b_date,;
>>dataf.age, dataf.sex, dataf.bus_no, dataf.locker_no;
>>FROM (dataf), (imgidf);
>>WHERE imgidf.frame_id = dataf.frame_id;
>>INTO TABLE (fname)
>>
>>In 5.0, it returns all fields joined to all fields. I used the 5.0 query wizard to produce the following test. It works correctly.
>>
>>SELECT _354428st.frame_id, _354428st.stud_id, _354428st.f_name,;
>> _354428st.l_name, _354428st.grade, _354428im.frame_id,;
>> _354428im.filename;
>> FROM 354428st _354428st INNER JOIN 354428im _354428im ;
>> ON _354428st.frame_id = _354428im.frame_id;
>> ORDER BY _354428st.frame_id
>>
>>However, when I try to convert my original query to 5.0 syntax (see below), it returns all fields joined to all fields.
>>
>>SELECT imgidf.filename, dataf.frame_id, dataf.stud_id, dataf.ssn,;
>>dataf.f_name, dataf.l_name, dataf.m_initial, dataf.address,;
>>dataf.city, dataf.state, dataf.zip, dataf.phone, dataf.prnt_name,;
>>dataf.prnt_phone, dataf.emer_name, dataf.emer_phone,;
>>dataf.tchr_name, dataf.homeroom, dataf.grade, dataf.b_date,;
>>dataf.age, dataf.sex, dataf.bus_no, dataf.locker_no;
>>FROM (dataf) INNER JOIN (imgidf);
>>ON dataf.frame_id = imgidf.frame_id;
>>INTO TABLE (fname)
>>
>>Can anyone give me a hand here.
>>
>>Thanks,
>>
>>Alex Shoob
>
>Assuming that "dataf" and "imgidf" are the aliases (since they're used in the fields list), you need to remove the paraenthesis surrounding them in the FROM and JOIN clauses.
>
>hth,
>
>George

George
I removed parentheses and all is now well. Thank you very much for your help.

Alex