• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Recent content by jaryszek

  1. J

    Solved Joining not primary key with enforcing referential integrity

    thank you Guys!!! Yes i am always asking because when i am doing something i do this in good way :) Or trying to understand all and be sure what i am doing. After discussion i fixed relationships: Thank you Guys for sharing with your knowledge and magnificient experience. Best, Jacek
  2. J

    Solved Joining not primary key with enforcing referential integrity

    Hi Guys, I have relationships something like here: And also i am using tblVolumes and there i have reference to serverClassID (i am not using relationships here because i have already used them in seperate case as above). Now i got one new table --> tblServerDetails where i have also key...
  3. J

    Solved Join between specific version and "All" field

    thank you Colin
  4. J

    Solved Join between specific version and "All" field

    Thank you Guys! I will handle it now!
  5. J

    Solved Join between specific version and "All" field

    you mean something like here? https://razorsql.com/docs/access_alter_table.html
  6. J

    Solved Join between specific version and "All" field

    thank you Colin, this is nice but what if you would have it will required all the time manually input system name into first part of union query. Jacek
  7. J

    Solved Join between specific version and "All" field

    thank you very much!
  8. J

    Solved Join between specific version and "All" field

    thank you arnelgp, it is nice solution. I am wondering if plog can figure out something more with his query. i like the most solution
  9. J

    Solved Join between specific version and "All" field

    thank you theBdGuy but this is short time solution, instead of Windows i can have a lot of differents strings which i can not predict. The_Doc_Man - i do not understand plog - o wow nice!! It seems to be ok. But one question. What if i will have nulls in table ? I will match records with nulls...
  10. J

    Solved Join between specific version and "All" field

    theDbGuy thanks but it is not problem here. I need to join 4.1, 3.1 and each version to "All". i do not have any nulls here.
  11. J

    Solved Join between specific version and "All" field

    Hi Guys, i have 2 tables: and : What i want is to get left join between AppVersion and System from TAble2ToJoin and get all matching records but inclusind relation "AnyVersion" to "All". So all versions (4.1,3.1, etc.) should be joined with "All" from Table2Join. Result table should...
  12. J

    Joining nulls

    Thank you very much for very nice explanations, especially thanks for The_Doc_Man! I will sit on the weekend and learn from you more!
  13. J

    Joining nulls

    thank you The_Doc_Man. ok it is confusing a lot for me. You can join on not indexes fields. and you do not have to use where clause then. What is the difference then? and error is: so JOIN is not working but if i understand this correctly: 1. using indexes can fasten using all joins 2. JOIN...
  14. J

    Joining nulls

    Ok, thank you. I added indexes to Field1 and Field2 in both tables (Table1 and Table2) and no have nulls: This is working: 1. but when i try to use only JOIN (without INNER string) i am getting error, why? 2. When i do not have indexes on Field1 and Field2 in Table3 and Table4 i can use...
  15. J

    Joining nulls

    Thank you very much! So in my example from post #16 if i had not nulls and created indexes on field1 and field2 in both tables i would use join without WHERE clause? And if i woud not have nulls there but also no indexes also i could use Inner join instead of left join with where clause...
Top Bottom