filter oder record on tacle (merged 3) [message #381569] |
Sun, 18 January 2009 10:59  |
haibec
Messages: 1 Registered: January 2009
|
Junior Member |
|
|
Hi all!
I have table USERS include fileds
ID, USERID, PRODUCT_ID
Now , I want promotion for product have code (PRODUCT_ID = 26). When user insert into table are order number 100,200,300 i will view name that user. Plase help me SELECT statement for this problem.
Thank
|
|
|
Re: filter oder record on tacle (merged 3) [message #381573 is a reply to message #381569] |
Sun, 18 January 2009 11:27   |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
1/ Don't multipost your question
2/ Your question is not understandable. For instance, what does this mean " I want promotion for product have code"?
3/ Post a Test case: create table and insert statements along with the result you want with these data.
4/ Also always post your Oracle version (4 decimals).
Regards
Michel
[Updated on: Sun, 18 January 2009 11:28] Report message to a moderator
|
|
|
|