>Hi Cetin,
>
>Sorry to bother you again.
>
>The SQL SELECT ran after I recoded the commands to match your example. Thanks for that example. I see the difference. I never had to qualify table names before. This is all new to me.
>
>I only have one final question. I was expecting to see translated descriptions from my translated codes appear in my CURSOR named rpt which later goes into my report. WHen I browse my CURSOR named rpt I don't see the descriptions which I thought were just JOINED from each of the 6 translate tables. Does that mean I am doing the wrong kind of join?
>
>I want "OTHER" to appear in rpt.desc1 so my report show OTHER and not OT (the code for other). But I have no field called desc1 in my CURSOR rpt. Or do I have to CREATE CURSOR rpt first and put those new fields in ahead of time, before SQL SELECT?
>
>Thanks for the final time today. I really appreciate your time and effort.
Steve,
As I can remember your SQL you were only selecting fields from aed_info (or first table - select aed_info.* from ..). Other tables had actually no effect on result other than acting as a kind of filter. If you want descriptions etc from them than specify in field list (also changing headers as you want) :
select a.myfield1 as "ItemCode", ;
b.mySomeField as "Location", ;
b.ot as "Other" ... from ...
Cetin