My original upload file contained over 6,000 entries, could this explain the weird query behavior?

Hrmm, Im seeing some weird reults here. If i do a select * from upload I see the people code id's of the people who should NOT be appearing in...

The people code id is unique. The query with the left join returns IDENTICAL results to my other query. Ive verified the data is in the excel fil ei uploaded,...

That wasnt the solution, i have several people who appear who are already on my original list (members2007a.txt) several people are being pulled on the query, even though the...

Will do, thanks for your help!!

Kenneth Fisher (10/11/2007)

---

select distinct p.first_name

,p.last_name

,p.people_code_id

from people as p

inner join peopletype as pt

on p.people_code_id=pt.people_code_id

where p.deceased_flag='n'

and pt.people_type='alum'

AND NOT EXISTS (SELECT * FROM Upload WHERE Upload.First_Name = p.First_Name

AND Upload.Last_Name = p.Last_Name

AND Upload.People_Code_Id...

Would something like this work?

select distinct p.first_name

,p.last_name

,p.people_code_id

from people as p

inner join peopletype as pt

on p.people_code_id=pt.people_code_id

left outer join upload as u

on p.people_code_id=u.people_code_id

where p.deceased_flag='n'

and pt.people_type='alum'

and p.people_code_id not in (select people_code_id

from...

I have uploaded the data into a table named "upload" the columns are:

first_name, last_name, people_code_id

my query to return ALL of our people code id's that i want/need is this

select...

But im not sure how to "update it to add missing rows"

Think i found it.

"Most likely it's because in queries only rows for which the WHERE clause condition evaluates to TRUE are returned. Rows that evaluate to FALSE or UNKNOWN...

I actaully read that as part of my research, but im not searching or comparing null values, i just want them to be displayed, what am i missing here?

sample data

what is displayed:

taco bell

kfc

mcdonalds

what i would like displayed

taco bell

null

null

kfc

ect....

Basically if a person has Null data in this field, i would like that to be displayed even though i...

wow, so all i need the whole time was to copy this code in a empty cell =RIGHT(TEXT(A1, "0000000"), 7) and that would pad it AND pull the first seven...

Thanks!! That was it, i didnt know it had to be an empty cell, and i already had the cells padded, that probably why the other one didnt work. Thanks...

I dont know how to check pm's. I dont know what the hell im missing here, this just isnt working.

Ok, lets say cell a1 has the value 0000000000000011234

I highlighted the...