Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by markhan

  1. markhan

    Forcing Index

    Thanks for the answer. After some changes, finally ,the index seems to work and my queries have been speeded up. I cant reindex thats why i was asking about forcing indexes. thank you so much ;) Regads
  2. markhan

    Forcing Index

    Hi all! Lets see if someone could help me with this... Database: Access 2000 Indexes for log table: Ix(A,B,C,D) PrimaryKey(D,B,A,C) I cannot change the index, so I have to use those ones When im running this query: SELECT A,B,C,D FROM log WHERE A='a' AND B='b' AND C='c' AND (D<d1) AND E>=...
  3. markhan

    SQL long waits for the query

    Thanks both for the replies :) The main program is a real time app updating a database each 5 secs. The application I have to do has to obtain data from the database and process it. Right now Im just using my app, the database is locally. Database: ACCESS 2000 Talking about the query: The...
  4. markhan

    SQL long waits for the query

    Hi all! Well lets see if someone could help me a little bit and give me some guidelines about what can i do... Database: Access 2000 Rows: 1.8Millions LD = is a Date There are no relationships. The database is like this: SN GN VN LD LV LQ LA...
  5. markhan

    Access SQL query ---&gt; SQL SelfJoin

    r937 You were close to the solution but probably we misunderstood each other. :/ sorry about that. I really appreciate all the time you spend to find the solution. Aswell i thought the solution of my problem was harder than i expected :/ In my #1 post i wrote this query SELECT l.SN, l.VN...
  6. markhan

    Access SQL query ---&gt; SQL SelfJoin

    r937 Thanks for the help by the way i was showing the 2 select query i was using since the beginning ;P
  7. markhan

    Access SQL query ---&gt; SQL SelfJoin

    Omg thanks a lot :((( (So much time wasted ¬¬) I didnt even need 2 selects :( Where were you PHV!! i needed you before!! haha just kidding ;) Thanks a lot This ends the question I just needed more group by...
  8. markhan

    Access SQL query ---&gt; SQL SelfJoin

    Yep I tried the query with group by but it doesnt achieve all the conditions I need. with group by shows all the values for the minimun LDs each. I have 2 options: 1º Use 2 Selects (As right now) 2º Use a Self join? (Is this possible) If so is more efficient than 2 Selects?
  9. markhan

    Access SQL query ---&gt; SQL SelfJoin

    :/ Ok... Sorry for the bad explanation. I need to check 3 conditions and from those conditions get the minimun value. So if i have this table: SN VN GV LD a a1 a2 1 a a2 a3 2 X Y Z 1 X Y Z 2 x b c 1 b b b 2 -------------- Conditions: SN = 'X' AND VN = 'Y'...
  10. markhan

    Access SQL query ---&gt; SQL SelfJoin

    Thanks for the reply but that doesnt fit with what i want. I need to show in the query SN, VN, GV and LD. If i use the query you say It will only show LD value and i need all the values. IE. SN VN GV LD a a a 1 b b b 2 With your query the result it would be: LD 1 The result i need...
  11. markhan

    Access SQL query ---&gt; SQL SelfJoin

    Hi all! I was wondering if someone could help me a little with this query. My intention is to use a Self join but i'm not transforming the query properly. Database: Access 2000 My actual query is like this: SELECT l.SN, l.VN, l.GN, l.LD FROM l WHERE (((l.SN)='X') AND ((l.VN)='Y') AND...
See more

Part and Inventory Search

Back
Top