General information
Category:
Coding, syntax & commands
>>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
Previous
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