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?


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.