469,270 Members | 1,796 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

SELECT query on joined tables

kiss07
99
Hi,

i have Two tables :

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 #1
2 849
can u explain it CLEARLY...
May 3 '07 #2
debasisdas
8,127 Expert 4TB
Is there any relation between these two tables ,please specify.

then it will be easier to understand the problem.
May 3 '07 #3

Post your reply

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

Similar topics

2 posts views Thread by allyn44 | last post: by
1 post views Thread by Carl B Davis | last post: by
14 posts views Thread by Tom | last post: by
2 posts views Thread by Fendi Baba | last post: by
1 post views Thread by racquetballer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.