SELECT directorysubmissions2.client_id,directorysubmissions2.client_title,directorysubmissions2.client_description,directorysubmissions2.client_url,directorysubmissions2.client_category,directorysubmissions.directory_id,directorysubmissions.directories,directorysubmissions3.progress FROM directorysubmissions2,directorysubmissions,directorysubmissions3 WHERE CONCAT(directorysubmissions2.client_id,directorysubmissions.directory_id) != directorysubmissions3.progress Here I am trying to see where something is NOT there. I got it to work like this a little.. If there is no match at all it shows me everything, but if there is 1 match it starts to show me all the data twice or three times. I would like to show the results where the numbers do not match and NOT show the results when the numbers do match. In "progress" there is no entry until it is finished. But when there is an entry there it shouldn't give me any output where those entries match while giving me the other entries that have nothing or no match. But it seems to be multiplying it more than anything. I have tried NOT EXISTS but it gives me either everything or in the case of one match ALL NOTHING.
What database and version are you using? Looks like MySQL, but I wanted to verify before answering. Also, the version number is important as the syntax changes from version to version.
Try joining the tables. A Left Join will show you all the values in the 1st table & the values in the 2cd table if the join is found..it will have a null value if the join is not found for the record.
He is joining the tables. That is what the commas are for. The specific database and version will determine how those joins are seen (since there are multiple joins) and whether the where clause effects the join (in some instances a where like this is the join conditional) or the individual records.
The version is 4.1.22. and in theory like it is will work, but like it is gives me an all or nothing result instead of a where some are true and where some are not true. For the time being I have changed it to a if A > B then show me everything else but it's somewhat less accurate because anytime someone get's ahead of themselves they clear out anything below the id.