IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Pls help me to write the SQL for the query


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
juneja_saveen

New User


Joined: 17 Jun 2005
Posts: 6

PostPosted: Wed Aug 23, 2006 5:25 pm
Reply with quote

Hi Everybody

Pls help me to write the SQL for the following query: -

Customers who made a distribution in Jan, Feb March 2004 and have not booked or distributed since. Customers who have made a distribution in January February March 2005 and have not booked or distributed since then.

Thanks in advance.
Back to top
View user's profile Send private message
senman

New User


Joined: 17 Aug 2006
Posts: 17
Location: Chennai

PostPosted: Wed Aug 23, 2006 5:39 pm
Reply with quote

Could you specify the necessary fields in the table
Back to top
View user's profile Send private message
punith007
Warnings : 1

New User


Joined: 16 May 2006
Posts: 11
Location: INDIA

PostPosted: Wed Aug 23, 2006 5:57 pm
Reply with quote

Please be clear Juneja !
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts RC query -Time column CA Products 3
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
Search our Forums:

Back to Top