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 Wanet Telecoms Ltd 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: *

  • Users: mrbti
  • Content: Threads
  • Order by date
  1. mrbti

    Compare Two Tables

    I have this sql query that compares two tables (t1 to t2) and creates a new table with anything that doesn't exist in the 'site' colum of t1: CREATE TABLE newtable SELECT t1.site, t1.rank FROM t1 LEFT OUTER JOIN t2 ON t2.site = t1.site WHERE t2.site IS NULL This works fine but I need...
    • mrbti
    • Thread
    • Replies: 4
    • Forum: MySQL
  2. mrbti

    Compare two large tables?

    I have two tables (table1 & table2) that contain fields ID and SITE. Both tables contain one million (1000000) rows each. I need to compare the SITE field in the tables to find out what data exisits in the second table that does not exist in the first. I have tried the following but because of...
    • mrbti
    • Thread
    • Replies: 2
    • Forum: MySQL

Part and Inventory Search

Back
Top