well you can leave them in separate tables. i only have experience with mysql and im assuming it is almost identrical as mssql. all you would need to do is: SELECT * FROM Reviews,ProductHardware WHERE Reviews.ID=ProductHardware.ID AND Review.ID="whatever_id_i_want" this is assuming that the ID's all corrisbond with eachother. is that how your keeping track of things? or are the ID's specific to that table, such as a key? what this will do tho, is take those 2 table and take the id u want to find, then take that single if from both tables. then you call call whatever data u want from those 2 tables. you could do a left join if u want, knd of compine the tables that way.