MYSQL :: Comparing Dates?

Comparing Dates
I have a problem with me. I am describing the whole situation. I have a table, the structure of the table is as follows:

Table Name: Announcement
FieldName Data Type(Size)
Announcement Varchar(50)
St_Hr Decimal(10,0)
St_Min Decimal(10,0)
St_Day Decimal(10,0)
St_Mon Decimal(10,0)
St_Year Decimal(10,0)
End_Hr Decimal(10,0)
End_Min Decimal(10,0)
End_Day Decimal(10,0)
End_Mon Decimal(10,0)
End_Year Decimal(10,0)

The data stored is:
Test Announcement,10,20,6,10,2005,11,0,8,10,2005

Now, I have to write a query to retrive announcements after filtering them as per the mentioned Starting and Ending Date & Time. The condition should use the local date and time.

Comparing Dates
I have a releaselist. All data before today should be deleted. How do I do this?

DELETE * FROM releaselijst WHERE Release < CURDATE()

doesnt work

Comparing Dates And Choosing
if( date_add(cur_date(), interval 30 day)>='$thisDate','$thisDate',date_add(cur_date(),interval 30 day)

So: if the current date plus 30 days is larger then thisDate, use thisDate else use the current date plus 30 days.

Comparing Dates Y, M, D , Time In Sql Query
ok.. ive finally got my nice little calender setup to output my dates

now

how do i query my database

for example ive got 2 variables
$startdate = 2006-1-1 00:00:01
$enddate = 2006-1-1 23:59:59

these represent the 1st and last second of the first of january 2006

i have a cell in my table (table called challenges) ( cell called time) that contains a date in the same format for each entry

how do i get all the entries between the start time and the end time..

can i use less than < and more than > as these are not really integar values

the column type is datetime but there is also another column of type datetime

Comparing Dates If One Is Unix Timestamp
I'm building a simple cms and i'm trying to get something done.. I store the dates as UNIX timestamps. However i want to add a feature let's say to display how many entries have been posted today. Something like [Articles posted today: 3]

Converting MS Access Dates To MySQL Dates During LOAD DATA INPUT ?
My insert code is below. The MySQL server is on my local machine and is version 4.1.22. I am exporting from an access table with 6 fields to a mysql table with those 6 plus 5 more fields. The main problem I am having SO FAR, is converting dates. The data file dates are formated like:
2/2/2006 0:00:00, 12/20/2006 9:22:05

Any ideas how to format those into mysql friendly dates?

Also, how do I convert currency fields in the load data process? I know you use SET by what kind of formula?

===========================================

LOAD DATA INFILE 'C:Documents and Settingspath_to_filedata.txt'
INTO TABLE auto
(field2, field3, field4, field5, currency_field6, field7, date_field8, date_field9)
SET id = MD5(UUID())
FIELDS TERMINATED BY ','
LINES TERMINATED BY '
'

How To List All Missing Dates Between 2 Dates
I have a database which stored financial data daily exclude weekend, however sometimes i tend to forget to upload data into the database. How do i write a sql query that would detect the missing dates between from last updated date until the current date.

Stroring Dates Perior To 1 AD, BC Dates
I need to store some dates that can be BC, However I received a problem indicating Incorrect Datetime.

I have read the documentation, and it says that Date&DateTime types can store from 1000-9999 AD, and Timestamp stores less year ranges. What other options do I have to store dates before 1000 AD !

List All Dates Between 2 Diff Dates
I have a database which stored financial data daily exclude weekend, however sometimes i tend to forget to upload data into the database. How do i write a sql query that would detect the missing dates between from last updated date until the current date.

Dates, Dates, Dates - Syntax Help Please!
OK, I have a MySQL table which contains, among others, a field called date which stores dates in the format YYYY-MM-DD HH:MM:SS.

What I'd like to do is select a list of all the months present (without repetition), preferably in the format YYYY-mm

Comparing Age
So the birthdays in my MySQL table are in a column called DOB and in the format of say: March 8 1985.
Now i have my own PHP function that will convert that to a nice numerical value of age relative to today, which is perfect. it is called getAge(). However, i can't seem to be able to parse an SQL query with that function inside...is there any way to parse my own PHP functions inside an SQL query?

Comparing
I'm currently working with two tables; A scheduling table and a document table. Basically I'm trying to make a query that says this -- "give me everything from this month and day in the Document table that's not in the Schedule"

Comparing A Csv To A Db Table
How would I go about comparing values in a CSV file to a table in the database, and then removing any rows where that value (an email address) matches? Is this something I can do in phpMySQL or will I need to create a separate PHP script or something?

I maintain a mailing list using something called ListMessenger. It's a great web application, but the one major drawback is that it doesn't have a way to handle bounces. Over the course of 5-6 years, I'm now up to around 800-900 bounced emails every time I send out a newsletter.

I'd really like to clean up the list and I was able to extract all the bounced address from my email client. I'm just not sure how to do it. I actually have an idea of what needs to be done... it's more the actual code to make it happen that I'm not sure of.

I'm thinking it would be something like this:

1. Open csv file and read values into an array
2. Run a SQL statement that removes any rows from the "users" table if the "email_address" field matches any of the addresses in the array.

Any help would be greatly appreciated. I can get into more specifics as far as the table/column names and stuff,

Comparing Tables
I have a query that produces a list of names of people who have completed a certain course. I want to be able to run a report which can show who has not completed this course. The code I have attached below just returns the same resut as those who have sat the course.

SELECT distinct pps_principals.name as pname, pps_principals.login, pps_scos.name, pps_transcripts.score, pps_transcripts.max_score, pps_transcripts.status
FROM (dbo.PPS_SCOS JOIN dbo.PPS_TRANSCRIPTS ON dbo.PPS_SCOS.SCO_ID = dbo.PPS_TRANSCRIPTS.SCO_ID)
JOIN dbo.PPS_PRINCIPALS ON dbo.PPS_TRANSCRIPTS.PRINCIPAL_ID = dbo.PPS_PRINCIPALS.PRINCIPAL_ID
where pps_transcripts.date_created between &#55614;&#57158;-12-01' and &#55614;&#57158;-12-31'
AND PPS_TRANSCRIPTS.STATUS like '[PCF]'
and pps_scos.name = 'COURSE1'
or pps_scos.name = 'COURSE1.1'
or pps_scos.name = 'COURSE1.2'
AND PPS_TRANSCRIPTS.TICKET not like 'l-%'
and pps_principals.name not in (
SELECT distinct pps_principals.name FROM (dbo.PPS_SCOS JOIN dbo.PPS_TRANSCRIPTS ON dbo.PPS_SCOS.SCO_ID = dbo.PPS_TRANSCRIPTS.SCO_ID)
JOIN dbo.PPS_PRINCIPALS ON dbo.PPS_TRANSCRIPTS.PRINCIPAL_ID = dbo.PPS_PRINCIPALS.PRINCIPAL_ID
where pps_transcripts.date_created between &#55614;&#57158;-12-01' and &#55614;&#57158;-12-31'
AND PPS_TRANSCRIPTS.STATUS like '[PCF]'
and pps_scos.name = 'COURSE1'
or pps_scos.name = 'COURSE1.1'
or pps_scos.name = 'COURSE1.2' )
AND PPS_TRANSCRIPTS.TICKET not like 'l-%'

Comparing Versions Of Sql
I'm taking up a new position and have never used sql before although use
and code in lots of other languages. When doing a bit of survey I find
many many versions of commercial and public versions of sql. Can anyone
tell me if the syntax is generally similar or are they completely
different. If I invest time learning mysql on XP or Linux will that be
useful if I end up using something like Oracle later on? The only one I
would avoid is MS.... like things that work occasionally.

Comparing Strings
I have a lot of records in a table named in this pattern "this text is the same.r01 someText (001/100)", "this text is the same.r01 someText (002/100)", "this text is the same.r02 someText (003/100)" etc.

The idea is that i want to automate the process of recognizing the files belonging to the same file(.r02 in this case), and then set a value which shows that is belongs to a certain fileID in another table.

The problem is that i have no idea what would be the best way to do this. My initial guess is that i would have to use a trigger and a LIKE clause comparing the "this text is the same.r02" part of the string, to see if it already exists in the database. If it does, i have to mark it as belonging to the same file.

I guess using a LIKE clause would be very slow, and the amount of records will grow quite big(millions of rows).

Comparing Tables
tablename: leftfile
Fieldname: leftword
Data: bbb
ccc
xxx
zzz

Tablename: rightfile
Fieldname: rightword
Data aaa
bbb
ccc
ddd
eee

I want to know which records in table rightfile do not match records in leftfile.
My assumption was that this should be possible with:
select rightword from rightfile, leftfile where rightword not like leftword.
The opposite query, which is finding a match between records works spot on:
select rightword from rightfile,leftfile where rightword = leftword.

Two questions:
1. What would be the proper method of achieving the desired result (all records from rightfile that do not have an equal record in leftfile)

2. I must be missing something important in my thinking. Why would my method not work?

Comparing Two Fields With LIKE
Here's the sql:

SELECT *
FROM boxer.lpars a, boxer.libraries b
WHERE b.lpars LIKE '%a.lpar%'
AND a.deleted = 0
ORDER BY node, lpar

b.lpars will commonly look like: "WIN1#WIN2#WIN3#WIN4#"
a.lpar will commonly look like: "WIN1"

When I run this query I get zero matches. What do I need to do to match fields using LIKE?

Comparing Two Table
I have two tables:

CREATE TABLE `FootballerScore` (
`footballerID` mediumint(4) NOT NULL default '0',
`GameWeekID` mediumint(4) NOT NULL default '0',
`GameRuleID` mediumint(4) NOT NULL default '0',
`Goals` mediumint(4) NOT NULL default '0',
`Assists` mediumint(4) NOT NULL default '0',
`CleanSheets` mediumint(4) NOT NULL default '0',
`YellCards` mediumint(4) NOT NULL default '0',
`RedCards` mediumint(4) NOT NULL default '0',
`WeeklyScore` mediumint(4) NOT NULL default '0',
`AccScore` mediumint(6) NOT NULL default '0',
PRIMARY KEY (`footballerID`,`GameWeekID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `footballers` (
`footballerID` mediumint(15) NOT NULL default '0',
`fname` varchar(15) collate latin1_general_ci NOT NULL default '',
`sname` varchar(15) collate latin1_general_ci NOT NULL default '',
`value` decimal(15,1) NOT NULL default '0.0',
`PremTeamID` mediumint(15) NOT NULL default '0',
`position` varchar(15) collate latin1_general_ci NOT NULL default '',
`Importance` varchar(4) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`footballerID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

The footballers table basically has a list of all the players in the premiership and the footballerscore table has a list of the player who played in a given week. For any one week I need to find out who DIDNT play. I can do this by comparing all the footballerIDs in both tables and the difference is the group I need. However I'm not sure how to put this into an SQL statement.

Comparing Tables
Let me set the scene for you. I have two tables on the same database:
hr_harassment (everybody who has already entered into a training class)
fields: lname, fname, class
hr_employee_list (everybody who needs to enter into a training class)
fields: Lname, Fname
I need to compare the two tables to figure out who has not yet signed up for the class. What would be the easiest way to do this? I am using PHP to program the page. I looked online and came up with this:

SELECT * FROM hr_employee_list AND NOT EXISTS (SELECT * FROM hr_harrassment AND hr_employee_list.Lname = hr_harrassment.lname AND hr_employee_list.Fname = hr_harrassment.fname)

But my browser tells me this:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in monitor.php on line 270

Comparing Two Sub_queries
I need to return the rows that are NOT duplicated. I am trying to be sure information on one db is the same on another db. I just need the odd rows returned. Is there an opposite of the union function?

EX> Query 1 returns

acct_num product_id     count
1507692    100000500    1
1846486    106            3
1846486    100000500    1

Query 2 returns the same.

I want the row returned if they aren't the same.

Data Comparing
i'm writting a program that uses my sql to compare a date time feild to a date that i have to count call on one date the statment looks like this:

SELECT Count(*) FROM wab_answers WHERE wabScreen=1 And DateDiff(answerTime,'" & curDate & "')=0;

where curDate is string containing the date that i would like to compare. I'm not to sure on the correct way to do this. Just need a push in the right direction.

Comparing 2 Tables
I have a table of users which is updated once a week by the client sending me a spreadsheet, and me uploading the CSV to my scripts which then import the data into the user table. This all works fine. However instead of sending me incremental data that can be just imported, the client has now taken to sending me a complete data list. The problem with this is that I cannot just empty the user table and re-populate with the new data as I will lose the primary key values which I use elsewhere.
My solution to this was to create a new table for importing with the same structure as my user table, import the csv to there, then somehow compare the tables and add the rows missing from the import table into the user table.

Comparing Times
I'm creating a voting system, and want to prevent people from cheating. Therefore I'm logging their IP, and the time they voted, and what I'm planning to do is have a script which will delete any records which have been in the database for say 24 hours.

To get the length of time I was gonne use:

HOUR(TIMEDIFF(NOW(),time))

Comparing Two Tables
I have to compare two tables. They are both of more than 650.000 rows, and I have to find which ones are missing in one of them. I have tried to first find all the rows in table A, and then search through table B to see if you can find it there. But this takes way to long time. Too bad mysql4 does not take subqueries.
Does anyone out there have a good idea to get this done?

Comparing Two Tables
I was wondering if there was a SQL command I could use that would find similar values from two specific columns in two different tables.. possibly an intersect?

heres what I mean

Table 1
blogTitle="I love soccer"

Table 2
articleTitle="Soccer is fun"

Is there a SQL command that would be able to find the similarities between each column in each different table if, lets say, the user entered "soccer" as a query?

Comparing Differences
I want to find the fields that are in table A but not in table B.
If I have:

table A: id, name, scoreA
table B: id, name, scoreB

I want to find the scores that are in table A but not in B, by example:

table a: 1,john,12|2,mike,14|3,neal,17

table b: 1,hellen,14|2,nolhan,12|3,vicky,10

After make the query:

Score in A that are not in B: 17

Query Help, Comparing Rows
Suppose I have the following data:

+----+----------+-----+-----+-----+-----+-----+-----+-----+
| Id | Time | Sun | Mon | Tue | Wed | Thu | Fri | Sat |
+----+----------+-----+-----+-----+-----+-----+-----+-----+
| 11 | 11:20:00 | F | T | T | T | F | F | F |
| 12 | 11:45:00 | F | T | T | T | F | F | F |
| 14 | 12:10:00 | F | T | T | T | F | F | F |
| 15 | 12:35:00 | F | T | T | T | T | T | F |
| 17 | 13:00:00 | F | T | T | T | T | T | T |
| 18 | 13:25:00 | F | T | T | T | T | T | T |
| 19 | 13:50:00 | F | T | T | T | T | T | T |
| 20 | 11:28:00 | F | T | T | T | T | T | F |
| 21 | 11:53:00 | F | T | T | T | T | T | F |
| 22 | 12:18:00 | F | T | T | T | T | T | F |
+----+----------+-----+-----+-----+-----+-----+-----+-----+
I would like to output the data by day pattern. I need some way to determine that in the above table, Mon-Wed is the same, Thu-Fri is the same and Saturday and Sunday are unique.

Comparing A Datetime Column
I am trying to write a query that will delete all rows that are older than a specified date.

The problem is that I am fairly new to mysql and that I am not quite sure about how I should compare something in the format yyyy-mm-dd hh:mm:ss.

Would converting that date format using UNIX_TIMESTAMP(), subtracting that from the current unix timestamp and then comparing be a good way to approach this problem?

Or are there other functions that may be easier to use?

Also, on a curious note.. how portable are these built-in mysql functions to other SQL software packages?

Comparing Date In Mysql
I am a new member to this forum.
I am developing a form using PHP - mysql in which i need to compare date with the date field in the datebase . the type is "date" in the format 'yyyy-mm-dd'.
can we use the variable which has a string of type 'yyyy-mm-dd' in the query itself by using > or < operators , i have tried but i m not getting the answer .
i m using two forms one in html to enter the dates by the user and other in PHP for querying the databse.

Comparing An Entire Row To Match Exactly
is there any way in which a MySQL query can compare all the composite primary keys of one table with their relevant foreign keys in another table.

I need to creat a query which in english says:

"find all the rows in table one where the composite primary keys of that row do not exist in the exact instance, in table 2"

eg. 1, 2, 3 is in table one but 1, 2, 3 IS NOT in table two, therefore return the row from table one.

Comparing String As Date
A client is using mysql 3.23 as database. He wants me to make a report where the dates are store in varchar columns. How do i convert string columns to date so i can made the ">" and "<" right??

Comparing Datetime And Time
I need to compare two values : the first one is in DATETIME format and the second one in TIME format. If I compare the two values with an usual operator, will MySQL extract the "time" part of the DATETIME and compare it to the TIME value?

If not, what function can I use to extract the "time" value? I have noticed the existence of TIME(expr) function, that extracts the TIME value from 'expr'... but it works only if 'expr' is a string, not a DATETIME.

Comparing DateTime Field To Now()
I am trying to have a select query which compares a Datetime field to the current date/time, Now(). Basically I want something to this effect:

SELECT Name FROM Lists WHERE expiration > 'Now()'

Expiration is a datetime field. The problem is It returns every name on the list except for ones with a value of 0000-00-00 00:00:00 whether or not the date has passed already. I have tried many other things including but not limited to

SELECT Name FROM Lists WHERE datediff(expiration,'Now()') > 0
SELECT Name FROM Lists WHERE timediff(expiration,'Now()') > 0
SELECT Name FROM Lists WHERE datediff('expiration','Now()') > '0'

and many other variations on those. The above 3 just returned a null recordset. How can I make this work?

Comparing 2 Tables For Differences
Trying to seperate data differences between 2 tables. Lets say i have 2 tables like the following

tbl_1
int_id - str_name
1 - Bob
2 - Roger
3 - Kim
4 - Jane

tbl_2
int_id - str_name
1 - Bob
2 - John
3 - Kim
4 - George

How could i construct a query to get results of the differences? Like seeing what names are in tbl_2 that are not in tbl_1? Or what is not in tbl_2 that is in tbl_1?

Comparing Strings With Accents
I want to compare strings with a select command.
In two tables, there are strings with and whitout accents, like "Cecile" and "CÃ©cile".

I don't know how I can get all the results for this kind of select :

select table1.givenname from table1,table2 where table1.givenname = table2.givename

I want to compare whitout accents but I don't know how to.

Comparing Data In 2 Tables
I have a table of users which is updated once a week by the client sending me a spreadsheet, and me uploading the CSV to my scripts which then import the data into the user table. This all works fine. However instead of sending me incremental data that can be just imported, the client has now taken to sending me a complete data list. The problem with this is that I cannot just empty the user table and re-populate with the new data as I will lose the primary key values which I use elsewhere.

My solution to this was to create a new table for importing with the same structure as my user table, import the csv to there, then somehow compare the tables and add the rows missing from the import table into the user table.

My question then, is this possible using a SQL query. Can I compare 2 tables, and add missing data from 1 into the other as new records? I could code a software solution, but with around 30k records in the user table I think a SQL query would be the best approach.

Comparing Tables With Mysql
I have 2 tables with the same format (same columns). Table 'a' is a subset of table' b'. I.e. in an ideal situation all entries in table 'a' should exist in table 'b'.
I can uniquely identify an entry using 3 fields (no SQL key is setup)

I need to write an SQL query (or a few queries) that will compare the 2 tables and output:
Records that are in A but not in B
Records that exists on both (i.e. key match) but are different (any other value but the key is different).

Comparing Data From 3 Tables
I am trying to wrap my head around the sql statement needed to get the data I need by comparing three tables.
I have three tables: authors, submissions, and ratings.
I need to see all the submissions that a specific author has not rated.

In other words, I compare the submissions table to the ratings table and find instances where there is a submission but not a rating from a particular author (signified by the row rater_id)

I've tried different combinations of INNER and OUTER joins, unions, subqueries... and nothing is working for me.

Comparing Partial Strings
Suppose I have a varchar field "A" in my table that has a value '120 g'
I have a variable $weight=120;

Now I want to run a query which compares $weight to 120 of field A

Can I do that? I think I will have to extract the number from 120 G and then do the comparsion.or something like that/

Comparing Multiple ID Fields
I have an advert table which contains three category ID fields (catid, catid2, catid3). These catid fields match up with the catid field in the category table. I want to run a query that returns any row that contains any mention of a specific category.

SELECT * FROM advert, category
WHERE advert.catid = category.catid
AND advert.catid = '3'

The above query works fine for the first advert.catid field, but once I introduce...:

OR advert.catid2 = '3'

... the results start getting strange. The same row is returned 9 times.

Comparing A Field With A String
I would like to run a select statement against a table, with a where condition that a field (less all it's non-alphanumeric chars) = a string. Ordering is important.

For example the following should all evalute true,
'1 2 3' = '123'
'1"2£3' = '123'
'1 23' = '123'
'(abcde)' = 'abcde'

where as these should evaluate false,
'123' != '321'
'1a23' != '123'
'abc' != abcd'

I have a sinking feeling I need regex for this, which is unfortunate as I know none.

SUM Query And Comparing Values In WHERE Clause...
Here is my query:

Comparing Two Tables Identical Structure
I'm a bit of a newbie, but have worked through a lot of queries and have had great success, until now.

MySQL version 4.0.27 (hosting limitation)

I have two tables where the structures are identical. The only things that are different are that some rows in one are not in the other, and the data in the fields of matching rows are possibly different values. I was hoping there would be a query that would select rows in the first table that have a field that matches a field in the second table, but has different data in any of certain other fields. The first field "name" is the primary key for both tables.

I know that is a mouthful, so more specifically, and simplified...
Table one and two have 'john' in the 'name' field. The other fields, 'level', 'location', 'rank', 'posts' might have different values. The same for other matching names. I want to select all the rows where the names match, but any of the fields do not match.

I've tried a few different queries but throw errors. Mostly on how to compare the fields.

Could someone reply with some examples or direct me to some reading on this subject? I'm learning a lot about MySQL through all this, and willing to learn more.

Comparing String Values In Two Different Columns
I am trying to do a string comparison between two columns located in two different tables. I tried the following SQL statement and it didn't work. This string comparison is for updating foreign keys in the referencing table.

sn-table (referencing)
e-table(referenced)

update sn left join e using(id)
set sn.Eid=e.id
where sn.name like e.name;

Although the command runs fine, it doe not produce the desired outcome!

I've seen SQL statements where comparison with a literal string works:

...
...
where sn.name like 'TX';

I want to compare variables not literals. I am trying to find a partial match between name on sn and name on e and then update FK in sn using corresponding id from table e.

Comparing Data In Multiple Table
In my db I have multiple tables, which are versions of the same table from different days. I import the data daily by renaming the old table to table_name_date and then importing the new data into a freshly created empty table. This gives me the following tables:

mysql> show tables;
+-------------------+
| Tables_in_mydb |
+-------------------+
| custinfo |
| custinfo_0206 |
| custinfo_0207 |
+-------------------+

The columns are obviously the same in each table:
mysql> describe custinfo;
+-------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| id | int(11) | NO | PRI | | |
| x | int(11) | NO | | | |
| y | int(11) | NO | | | |
+-------------+---------------+------+-----+---------+-------+

what I woud like to do is to query all "x" from each of the tables and compare them. I can obviously query for "x" in custinfo and then for "x" in custinfo_0207 and compare them, but can I do this in one query?

Ideally what I would get is something like that
+-------------+---------------+--------------+-----------------+
| Field | custinfo_0206 | custinfo_0206 | custinfo_0207
+-------------+---------------+--------------+-----------------+
| id | 1 | 1 | 1 |
| x | 5 | 4 | 2 |
| y | 150 | 150 | 135 |
+-------------+---------------+------+-----+---------+-------+

Is that possible?

Comparing Strings And String Concatenation
i am just learning sql and am having trouble doing a query on strings and concatenation

what I need to do is compare the registered owner's name with the ticketed driver's name. problem is, registered owner is one string and driver's name is separated into LastName and FirstName.

I need to list the ticketed drivers who were issued a ticket while driving another person's vehicle.

select FirstName, LastName from driver,vehicle,ticket
where vehicle.regowner not like concat(driver.FirstName,'',driver.LastName)

Comparing Two Tables And Saving The Differences In Another
I am trying to take a new table of info and compare it to an existing table. (both are lists of names and ssn's.) The missing ones are the ones needed to put in to the existing. I also have to add some dates and payment info not in the existing.
So.

I cannot find the comparison method that outputs the nameLast and nameFirst that is in one table but not the other.