I have two tables I just what the data from the 1 table that is not in the
2 table So in this example I what row formelements_id 22 and 23. I have
tried different sql statements one is below

 
SELECT customformelements.formelements_id
,dbelements.customer_id,customformelements.formelements_field_type,
customformelements.formelements_field_caption FROM customformelements
,dbelements WHERE customformelements.members_id = '8' AND
customformelements.formelements_id <>dbelements.dbelements_field_name
 
Of course this will loop through and give me every field that does not equal
18 which is all but 18
Any Suggestions
 
1 Table
 
formelements_id     formelements_field_type   formelements_field_caption
members_id 

        18                               text
Data1                         8
        19                               date
Data1                         8
        20                               text
Data1                         8
        21                               text
Data1                         8
        22                               text
Data1                         8 
        23                               text
Data1                         8
 
 
 
2 Table
dbelements_field_name   dbelements_field_value   members_id    customer_id

                18                            This is a test
8                 17
                19                            This is a test
8                 17
                20                            This is a test
8                 17
                21                            This is a test
8                 17
                18                            This is a test
8                 59
                19                            This is a test
8                 59
                20                            This is a test
8                 59
                21                            This is a test
8                 59

Reply via email to