Greetings,

I am having some trouble with a join (I think that is what I need to
be using)

I have one table 'PPData_Fusion' that contains customer info. I have
another table 'FusionResults' that contains submitted form data along
with a column that is found in both tables 'pick_pull'

I have a mouseOver code that displays fields from the PPData_Fusion
table which is why I have the PPData_Fusion table in the equation. I
could easily just query the FusionResults table for null and not null
filed values but I need a bit more than that.


I want to join both tables where PPData_Fusion.pick_pull =
FusionResults.pick_pull and I also want to only grab the records from
the FusionResults table a dateRcvd is null.

I am getting a few duplicates when I perform this query because I have
a few records in PPData_Fusion that have the same pick_pull value.

My main criteria is that I return all the records from the
FusionResults table where the dateRcvd field is NULL.




My code:

MySQL = "SELECT FusionResults.*, PPData_fusion.salesperson,
PPData_Fusion.dateEntered, PPData_fusion.orderDate,
PPData_fusion.accountName, "
MySQL = MySQL & "PPData_fusion.clientContact, PPData_fusion.email,
PPData_fusion.billingDate FROM FusionResults, PPData_fusion WHERE
FusionResults.pick_pull = PPData_fusion.pick_pull"
MySQL = MySQL & " AND FusionResults.dateRcvd IS NULL"

Thanks all!

Joe