asked on

how to get data from same table

HI everyone,

i have a table which go all the information of orders,

Cust-number style-code qty and date-time

customer number can be repeated as one custoemr can place many orders and probably have place many orders in same date-time.

what i want is

Select * from [offercom]
where style_code in(style codes.)
but i need other information as well as which people have ordered other stuff includin gthese specific styles.

ammartahir1978

ASKER

here is the original data
2,272,771 18P02 PRINTED BANDED DRESS INTERNET 1.00 20/11/2007
2,272,771 08N28 BELTED JERSEY DRESS INTERNET 1.00 20/11/2007
2,272,771 12P06 TWILL PANELLED SKIRT INTERNET 1.00 20/11/2007
2,272,771 17P04 PAISLEY SHIRT DRESS INTERNET 1.00 20/11/2007
2,272,771 17P06 DAISY PRINT SHIRT DRESS INTERNET 1.00 20/11/2007
2,272,771 06P04 ROLL NECK KNIT DRESS INTERNET 1.00 20/11/2007
2,350,216 10P14 SUPERSOFT LUREX ROBE INTERNET 1.00 20/11/2007
2,350,216 14N12 BOOTLEG JEAN 36" INTERNET 1.00 20/11/2007
2,340,542 14N32 BOOTLEG JEAN 38" INTERNET 1.00 20/11/2007
2,237,158 18P05 JERSEY SHIRT DRESS INTERNET 1.00 20/11/2007
2,237,158 07P27 SEQUIN TUNIC INTERNET 1.00 20/11/2007
2,334,543 05P24 SEQUIN CAMI INTERNET 1.00 20/11/2007
2,334,543 11P05 STAND COLLAR BELTED JACKET INTERNET 1.00 20/11/2007
2,334,543 06P19 ANGORA MIX CARDIGAN INTERNET 1.00 20/11/2007
1,369,734 05P24 SEQUIN CAMI INTERNET 1.00 20/11/2007
1,369,734 05P24 SEQUIN CAMI INTERNET 1.00 20/11/2007
1,369,734 07P26 COVER UP INTERNET 1.00 20/11/2007
2,369,455 03P02 MULTI STITCH LINEN CROP INTERNET 1.00 20/11/2007
2,303,385 10P06 STRIPE T SHIRT INTERNET 1.00 20/11/2007

the deesired result is
if any customer had bought the items in IN STATEMENT
the result should bring other items of purchase also for that specific customer

for exampl

customer number 2772771 bought 18P02 as this is in my statment that if a customer bought 08p02 what else he have bought
so the result should be

2,272,771 18P02 PRINTED BANDED DRESS INTERNET 1.00 20/11/2007
2,272,771 08N28 BELTED JERSEY DRESS INTERNET 1.00 20/11/2007
2,272,771 12P06 TWILL PANELLED SKIRT INTERNET 1.00 20/11/2007
2,272,771 17P04 PAISLEY SHIRT DRESS INTERNET 1.00 20/11/2007
2,272,771 17P06 DAISY PRINT SHIRT DRESS INTERNET 1.00 20/11/2007
2,272,771 06P04 ROLL NECK KNIT DRESS INTERNET 1.00 20/11/2007

arunyeshi2000

Why dont you just do a select * with order by Customer Number and style code...
select * from [offercom] order by customer,style_codes

ASKER CERTIFIED SOLUTION

deroby

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ammartahir1978

ASKER

i want is

customer who order the styles and also have ordered other stuff with the style included in IN statement

hope this explain

imitchie

try this pattern from your other question

select * from [offercom]
where CustomerID in
(Select CustomerID from [offercom] where style_code in (style codes)
where ... date filter ... other filter...
)
and ... date filter ... other filter...

deroby

[customer who order the styles and also have ordered other stuff with the style included in IN statement]

Actually, this makes it even less clear =) Anyway, according to the example you gave, I think that the code presented by imitchie & me should do the trick alright.