I have a couple of tables I'm joining and only want to return users that a field missing in the joined table. Users id fname lname userMeta id metaKey metaValue…
Read More
I was trying to figure out a query to count the IP addresses I had in a table, tell me how many are the same, then delete duplicates only leaving…
Read More
Basic syntax for using case when statements in SQL. For this example we want the following: If Field1 = 2 and Field2 = 2 then use the date in Field3…
Read More