Member Avatar for veledrom

Hi,

select id, pay from def_1 where id = (select id from def_2) and pay = (select pay from def_2)

This generates an error "Subquery returns more than 1 rows".

Where is mistake?

Thanks

  • 1 Contributor
  • 1 Reply
  • 82 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by veledrom
Member Avatar for veledrom

Solved.
Use IN instead of =

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.