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