Home » SQL & PL/SQL » SQL & PL/SQL » IN List
IN List [message #192300] Mon, 11 September 2006 13:23 Go to next message
rajaguru_t
Messages: 7
Registered: September 2006
Location: India
Junior Member

Hi ,

I've a query like

select specs,ants from species where specs in ('ext','int','out');

By some trick, I would like to get all the three rows returned for specs whereas the outcome on ants should still depend on the specs present in species.

It would be very nice of him/her if I get the answer pls.
Thanks,
Dun.
Re: IN List [message #192354 is a reply to message #192300] Tue, 12 September 2006 00:51 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Instead of guessing, I would like to see a create table statement, insert statements for sample data and a formatted expected output: use the tags [CODE] and [/CODE] to preserve formatting. Something like this:
ANT   <whatever columns you want>
----  ---------------------------
Blah  .....


MHE

[Updated on: Tue, 12 September 2006 00:52]

Report message to a moderator

Previous Topic: wht would be my primary key
Next Topic: Update based on Select Query
Goto Forum:
  


Current Time: Sat Dec 03 09:47:22 CST 2016

Total time taken to generate the page: 0.09581 seconds