Member Avatar for nice_true
nice_true 0 Light Poster

Hi!

The problem is that, when I write the following text as a query and try to run it, it returns 0 rows

'select * from receipts where grno not in (select grno from gate)'

But when I write the above text in a stored procedure and then call it in the query analyser, it returns the required number of rows.


Can anyone help me out?
Why is this so?

  • 1 Contributor
  • 0 Replies
  • 49 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.