Search results
-
J
Solved SQL to append new columns to table
Thank you Guys, i needed cross join here, Best, Jacek -
J
Solved SQL to append new columns to table
Thank you, let's wait i want to know it :) And will decide. Best, Jacek -
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 -
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... -
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... -
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 -
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 -
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... -
J
Append if rows do not exists else update if exists
What is the difference? Best, Jacek -
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... -
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 -
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 -
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... -
J
Append if rows do not exists else update if exists
thank you very much let me test it Jacek -
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 -
J
Append if rows do not exists else update if exists
Hi Guys, long time since i have been here (we moved to Excel entirely :( ) i have 2 tables: ID is a key for us. t_AnimalInput ID Animal Color 1 Dog Green 2 Cat White t_AnimalSource ID Animal Color 1 Dog Green 2 Cat Black 3 Mouse Red and now expexted result is... -
J
Transform PostgreSQL to Access SQL
Thank you for your voice Pat. It would be nice to see update but who knows how microoft will support it -
J
Transform PostgreSQL to Access SQL
BTW. No other database has drag and drop editor like Access which fasten writing sqls so so much for me. -
J
Transform PostgreSQL to Access SQL
Pat, thank you. I saw few converters online but hmm they were not efficient unfortunately. There are also paid tools which can transfor access sql to postgresql but i do not know which to choose and what to use. This is why i wrote the question - maybe somebody has more experience? Best, Jacek