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