Member Avatar for firoz.raj

Can anyone tell me .what will return this subquery.any help would
be Greatly appreciated.kindly help me.it will return single row or
multiple row if single then how.kindly let me know some idea.

select * from sub where job=(select job from job)
  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by cgyrob
Member Avatar for cgyrob

Not sure what you are asking. This statement will most likely return an error. (Multiple values returned when expecting single value)

To make it work you will either have to use an "in" instead of "=" for your sub query or use a where clause within your sub to limit the return values to one value.

Select * from sub where job in (select job from job)

or

Select * from sub where job = (select job from job where value = something )
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.