I want to make a sql query, stored procedure, or whatever which will:
Say there are two tables [Computers] and [Hard Drives]
Computers (Computer_ID, Host_Name, Etc)
Hard Drives(Hard_Drive_ID, Size, Computer_ID<--foreign key)
I want to select all computer_id's from computers where there does...