Hi all,
We use FP3.

I want to create a simple query, combining tisfc001 and tttxt010 , to get the texts and the production order.

I only need these data:
tisfc001.pdno , tisfc001.txta, tttxt001.ctxt, tttxt010.text.

the combination is simple,
tisfc001.pdno in column1, if tisfc001.txta=tttxt.ctxt, then in column 2 will have a value tttxt010.text.

Please help me , how to create a query for this.
Im a new bie in SQL Quey module, i only can to use one table.

Many thanks and rgrds
Adriane

Not sure I user stand - are you using easy sql? Just create a query for tisfc001. It would look something like this?

select tisfc001.pdno, tisfc001.txta
from tisfc001
where tisfc001._index1 = 100001


If not using easy sql - do it there first, generate the report - then go view the report to see how to handle text. Hope this helps.

Hi Mark,
Thanks for your response, i ve found the solution for it.
we only need to use one table, and define 2 field (pdno and txta), and the result is exactly what i want it to be.

Ill close it now.

Rgrds
Adriane

No reason to close the thread - someone else might come along and need to ask a question or two. The mods will close threads when it is needed.

Thanks