Search results

thank you very much!

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

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...

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.

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...

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!

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...

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...

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...

thank you once again The_Doc_Man, no i have very nice feeling because of youe help! I am realy appreciate your patient explanations ! Really helps!

o wow thank you Guys!!!! i understand!!!! this is very nice method. So plog you are not recommending to update table like i did just create matching keys, and the The_Doc_Man is recommending to do update to some specific values? Ooo this is the tip. So while creating tables the most...

thano you very much The_Doc_Man!!!

Hi Guys, thank you. Yes i know MajP solution because i started the topic. Now i want to just clarify why this is happening? Why this is not showing ID2 when at least one field has null in join? Why Access is not reading this? I just want to go deeper into access structure. The solutions is...

Hi Guys, thank you for your statemements. As Cronk told you can have for example people table withpout PK and you have to check what exists there. Table can have more than 15 atributes so you can meet more tahn 15 joins Guys...Espacially if you have not nice data. Let's look at this example...

thank you Guys very much! Ok, so The_Doc_Man to confirm to use join from my example you would also change null values to some unlikely value yes? To be sure that joins are working correctly?

And adding database as an example

Hi Guys, i want to ask you once again about nulls in tables. I created 2 tables: And now i create query to check if records in TempTable exists in Target Table: The result seems to be ok even i have nulls here. When i am joining much more fields, like 15 like that sometimes nulls is not...

thank you my friend. Sometimes like in real life you do not have choice. I am getting just very ugly raw data in csvs without primary keys and can not change model...

This is why i liked his post :)

Thank you However, it may be safest to manage NULL values by first setting them to valid but unused values in each field of the import & destination fields For example, update null dates to 01/01/9999 and number fields to an unlikely value such as -1000000 You will need to do this for each...