General information
Category:
Coding, syntax & commands
Title:
Converting 2.6 query to 5.0
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only