I know this might be a very simple one, but yet I can't figure that one out!
How do I get data from one table that are not in another?
Let's say Table ServerA has: IP, User, Password, Table ServerB has: IP, CanConnect.
If ServerA has 20 rows and ServerB has 13 rows. How do I get those 7 rows that are in ServerA but not in ServerB?
Here's what I got, but it's not giving me what I want:
SELECT ServerA.* FROM ServerA WHERE NOT EXISTS ( SELECT * FROM ServerB WHERE ServerA.IP = ServerB.IP)
SELECT ServerA.* FROM ServerA LEFT JOIN ServerB ON ServerB.IP = ServerA.IP WHERE ServerB.IP IS NULL
Any help would be much appreciated!