Recent content by jaryszek

  1. J

    Solved SQL to append new columns to table

    Thank you Guys, i needed cross join here, Best, Jacek
  2. J

    Solved SQL to append new columns to table

    Thank you, let's wait i want to know it :) And will decide. Best, Jacek
  3. J

    Solved SQL to append new columns to table

    Hmm and it is not possible to do this without additional tables only with SQL? Thanks! Best, Jacek
  4. J

    Solved SQL to append new columns to table

    Hi Guys, i have 2 tables: Table1 ID Pet Kind Color 1 Cat Mammal Black 2 Dog Mammal White and Table2 Table2 ID Food 1 Fish 2 Meet What i want to do is to get result like here: ExpectedResult ID Pet Kind Color Food 1 Cat Mammal Black Fish 4 Cat Mammal Black Meet 5...
  5. J

    How to merge 2 rows into 1 in query

    Hi, i have query like here: SELECT DeploymentName.Deployment, DeploymentName.Profile, Table2.ResultTable2, Table1.ResultTable1 FROM ((DeploymentName INNER JOIN Profiles ON DeploymentName.Profile = Profiles.Name) LEFT JOIN Table2 ON (Profiles.TableProfile = Table2.Name) AND (Profiles.TableName...
  6. J

    Append if rows do not exists else update if exists

    thank you Colin, you pointed me in proper direction! Yes, this would not append record so i have to do the solution in 2 queries: 1 to append and one to update rows... Best, Jacek
  7. J

    Append if rows do not exists else update if exists

    I tried with: UPDATE t_AnimalSource LEFT JOIN t_AnimalInput ON t_AnimalSource.Animal = t_AnimalInput.Animal SET t_AnimalInput.Animal = [t_AnimalSource].[Animal], t_AnimalInput.Color = [t_AnimalSource].[Color] Where t_AnimalInput.[Index]=1 but it failed
  8. J

    Append if rows do not exists else update if exists

    Ok Guys i have one more question. I would like to create new recordset from t_AnimalInput (UPSERT table but with condition). So in one sql to do: 1. Check if Index equals 1 or 2 and take only these rows to create upsert query 2. Check if rows exist in t_AnimalSource and append if not 3. If...
  9. J

    Append if rows do not exists else update if exists

    What is the difference? Best, Jacek
  10. J

    Append if rows do not exists else update if exists

    Tjhank you Colin, o wow you have very good memory, i ma jelous - when i learned some technical solution when i am not using...i am forgetting all :( Yes i became father and in 5 days i will be second time! :) Just using excel all the time, access not now but i learned a lot from you and other...
  11. J

    Append if rows do not exists else update if exists

    Yes i know Colin about your side, thanks for reminding :) Thank you Guys for help! Jacek
  12. J

    Append if rows do not exists else update if exists

    Thank you, works! so why this error were occuring? Can you explain? Best, Jacek
  13. J

    Append if rows do not exists else update if exists

    ok somehing is not working. I tried with access query design feature. I tried with: UPDATE t_AnimalInput RIGHT JOIN t_AnimalSource ON t_AnimalInput.ID = t_AnimalSource.ID SET t_AnimalInput.Animal = [t_AnimalSource].[Animal], t_AnimalInput.Color = [t_AnimalSource].[Color]; and i am getting...
  14. J

    Append if rows do not exists else update if exists

    thank you very much let me test it Jacek
  15. J

    Append if rows do not exists else update if exists

    thank you arnelgp. you would do this as second step after inserting rows? Best, Jacek
Top Bottom