Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^2: (OT) Exclusion selection on DBI

by fernandes (Monk)
on Jan 25, 2008 at 14:08 UTC ( #664285=note: print w/replies, xml ) Need Help??


in reply to Re: (OT) Exclusion selection on DBI
in thread (OT) Exclusion selection on DBI

Thank you very much for the advices. They have given to me deep insights about my problem. But I need to apologize Iíve not described the problem appropriately. I will try it again, here:

The complete table I have is like:

Fruit, colour, Id number of supermarket

I need to be able to select only the repeated fruits in two given supermarkets. So, if I have

Mellon, red, 1
Mellon, green, 2
Banana, black, 1
Orange, blue, 3

And if I want to get information about supermarket 1 and 2, the result will be

Mellon, red, 1
Mellon, green, 2

Iím using DBI module.

Thanks!

Replies are listed 'Best First'.
Re^3: (OT) Exclusion selection on DBI
by moritz (Cardinal) on Jan 25, 2008 at 14:14 UTC
    The additional requirement of the supermarket id just adds a WHERE clause WHERE supermarket in (1, 2).

    And of course the supermarket ID has to appear in your SELECT list.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://664285]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (9)
As of 2020-11-26 21:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?