Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL EXPRESSION

Status
Not open for further replies.

elly00

Technical User
Jun 30, 2011
69
IT

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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top