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 strongm 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. psarff

    searching multiple tables w/same fields

    I went with the union statement and it sort of works<br> "select * from table1 union select * from table2"<br> the problem is that it will list what i searched for at the top and then dump all of table1 just below! any suggestions?
  2. psarff

    searching multiple tables w/same fields

    I have set up a database with two tables. The tables contain all identical fields. ex: table1 has the fields name, address, and zip code. table2 also has name, address, and zip code does anyone know how I can set up my sql statement to search both tables and pull info from both tables?

Part and Inventory Search

Back
Top