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!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update a table with data from a select
I was trying what you posted and several variations, when I did not have any luck getting them to work with my database(SQLite3) I posted, thinking that I was overlooking something simple. What I came up with that worked is just have the select display what I need as SQL, copy it to a batch... -
Update a table with data from a select
I have a table that has some poorly formed data. A person can read it and understand it well enough to know what the person entering the data meant. Any program I make has lots of problems with it so I need to fix this data. I can create a select statement that uses the poorly formed data and... -
Recursive Select?
Thanks, a join(I did not know they could be used on the same table) with aliases solves problem #2 and is something I will put to good use in a lot of different problems. It also sujects a possible way to solve problem #1 SELECT A.UID, A.dam From cow A, cow B Where A.dam=B.UID Cow A is the... -
Recursive Select?
I am not sure that is the right topic name, it is as best as I can describe it though. I have one table, each record describes a cow and has a whole lot of data on each one. There are only three have a berring on my question. UID is a unique number used to identify each cow. Dam, is the UID of...
