Home » SQL & PL/SQL » SQL & PL/SQL » IN List
IN List [message #192300] Mon, 11 September 2006 13:23 Go to next message
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.
Re: IN List [message #192354 is a reply to message #192300] Tue, 12 September 2006 00:51 Go to previous message
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  .....


[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: Fri Jul 21 10:07:58 CDT 2017

Total time taken to generate the page: 0.12474 seconds