SQLTeam.com | Weblogs | Forums

How to make these tables



i have a table in ms access as checkpoints that has checkid as a unique field. I have another table as project that has a projectid and each of these projects can have different checkpoints. I don't know how to make this connection between these two tables. can you help me please?


Hello mana, this site is for MS SQL Server, however if you post more information about the two tables and the desired output we should be able to help. Depending on what you expect this might get you started:

SELECT p.mycolumn, cp.myothercolumn 
FROM project p
LEFT JOIN checkpoints cp ON p.checkpoints = cp.checkpoints