Re: Limiting the data returned to just what I need

2004-03-28 Thread Peter Frank Spierenburg
On Sun, 28 Mar 2004, Scott Haneda wrote: > Client wants a "hitlist" that shows the user data and the associated serial > numbers for a list of users. If the query returns 20 serial numbers, I am > going to get back 19 name, address, state, zip etc rows that I don't need, I > can easily discard th

Not unique table/alias

2001-05-08 Thread Peter-Frank Spierenburg
What does this mean? It is referring to the following SQL statement: INSERT INTO MaterialSubwall SELECT subwallClassId, mirrorEW, rotation + 180, sizeX, sizeY, offsetS, offsetW, offsetN, offsetE FROMMaterialSubwall; AFAIK, this