SQL EXPRESSION

[elly00]

Hi
I need to set a SQL expression that in sql is like that

select * from anagart where codiceart not in (select code from historycode)

in order to have a list of codart that is not included in the historycode table..

How can i do that?
When I try to specify that statment I receive an error that I cannot have multiply results

thank

 

[dgillz]

Are you talking about a SQL expression field or a SQL Command?

Macola and SAP Business One Consultant
Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[elly00]

SQL expression field..

 

[pmax9999]

A SQL Expression can only return a single value. If you know how to achieve what you want using a SQL query, copy that query into a Command and use that as the basis for your report.

Pete.

 

[dgillz]

Elly00,

Does this answer your question?

Macola and SAP Business One Consultant
Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[elly00]

Hi

yessssssssssssssssssss thanks