472,373 Members | 1,940 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,373 software developers and data experts.

maximum date and not zero records..

kiss07
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
3 1595
debasisdas
8,127 Expert 4TB
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
99
Dear Deba,

Both are Different tables i submit correct .But i dont Know whats my problem..
May 3 '07 #3
kiss07
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

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

Similar topics

3
by: Alistair | last post by:
it's the idiot with his query strings again...."yippeee" I hear aaron shout this time the problem is with a date format query I have a query string thus strSQL = "SELECT * FROM users where...
2
by: Hennie de Nooijer | last post by:
I have a problem (who not?) with a function which i'm using in a view. This function is a function which calculates a integer value of a date. For example: '12/31/2004 00:00:00" becomes 20041231....
2
by: Hennie de Nooijer | last post by:
Because of an error in google or underlying site i can reply on my own issue. Therefore i copied the former entered message in this message....
2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
1
by: William Kossack | last post by:
I have a table with a date/time field that is not required. The actual purpose of the field is to indicate when something was stopped. Therefore, in my select select field1, field2, dtfield from...
24
by: Agnes | last post by:
my date format is in yyyy-mm-dd mycommandtext is 'select * from myTable where issuedate >='" & Me.txtStartDate.text & "' and issuedate <= '" & Me.txtEndDate.text & "' " It return zero records,...
2
by: crackerbox | last post by:
I have a table that I need to find the maximum date per Doc_No per Parent_Doccategory. I can get the maximum date per Doc_No but I can't get the information for the next level. The following script...
6
by: =?Utf-8?B?U2hhcm9u?= | last post by:
I'm using the VScrollBar and set it as follow: m_vScrollBar.Minimum = -19602; m_vScrollBar.Maximum = 0; m_vScrollBar.SmallChange = 1; m_vScrollBar.LargeChange = 1089; m_vScrollBar.Value =...
10
by: janieavis | last post by:
If I run this query I can see there are 2 records with the dates 10 August 2009 and 24 August 2009: SELECT dbo_JobMain.BpaMainPKey, dbo_JobMain.JobDefinitionPKey, dbo_JobMain.Value,...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
2
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
1
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
0
DizelArs
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.