By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,540 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

maximum date and not zero records..

kiss07
P: 99
Dear friend,

I have two tables are there following below:


table a table b
--------- ------------
name associative salary date rank position
----------------------------------------- -------------------------------------------
arun member $500 12/03/07 first 89

kumar nonmember $400 23/03/07 second 0

manish member $40 10/04/07 first 0

nirmal member $78 25/03/07 nil 49

akash member $380 30/04/07 fifth 36

king member $576 22/04/07 second 3



I want to select all records in (table a) and maximum date , position is not zero records in table b.

how can do it. I want query..Pls help.

I expecting reply..

Regards..

Arunkumar..
May 3 '07 #1
Share this Question
Share on Google+
3 Replies


debasisdas
Expert 5K+
P: 8,127
Is structure of both the table A and B are same ?

and plese specify what is rank and what is position.
May 3 '07 #2

kiss07
P: 99
Dear Deba,

Both are Different tables i submit correct .But i dont Know whats my problem..
May 3 '07 #3

kiss07
P: 99
EMP
name associative salary

arun member $500

kumar nonmember $400

manish member $40

nirmal member $78

akash member $380

king member $576



POSITION

date rank value
------------------
12/03/07 first 89

23/03/07 second 0

10/04/07 first 0

25/03/07 nil 49

30/04/07 fifth 36

22/04/07 second 3


I want to select all records in (EMP) and maximum date , value is not zero records in POSITION TABLE.

how can do it. I want query..Pls help.

I expecting reply..

Regards..

Arunkumar..
May 3 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.