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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Brians440

    Syntax error on Union all SQL query WHERE statement

    Sorry for the confusion. I'm wanting to setup one "ID" that is global in nature. Case in point I'm going to have 10 files of the same type of data. Instead of having to change the "BAN" field 10x let's say from 9533 to 5119 for each union all, is there a way to set a global reference? So, I...
  2. Brians440

    Syntax error on Union all SQL query WHERE statement

    I have another question. Instead of putting in another value other than *9533* can I put one value = TEST and then in the query just have the WHERE statement read WHERE BAN LIKE '*TEST*'; That way I won't have to change the BAN statement 10X. Thanks
  3. Brians440

    Syntax error on Union all SQL query WHERE statement

    Hey thanks very much. I had the duplicates cause I was trying make it harder than it obviously had to be. Thanks again.
  4. Brians440

    Syntax error on Union all SQL query WHERE statement

    All, I'm trying to write a query to pull the same parameter data from 10 different files. I've started the first two and am already stuck I get "SQL syntax error (missing operator) in query expression '(((T_CABS_USAG.....and so on. Here's what I have so far. TIA Brian SELECT * FROM...

Part and Inventory Search

Back
Top