Jump to content

help writing a big query


cow.vs.cow

Recommended Posts

hello all !

 

i hope you'll have some good answers for me.

 

lest start.

i have 3 tables

A - inno_db - has 500,000 records

B - inno_db - has 40,000 records

C - temporary table - inno_db - has 80,000 records

 

all tabels are growing up more and more.

 

i need all the records from A that they are NOT in B AND NOT in C

 

using NOT IN is taking way to long and i'm sure that there's another better way..

thanx all

Link to comment
https://forums.phpfreaks.com/topic/144471-help-writing-a-big-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.