Yatin Dabhi Posted April 12, 2009 Share Posted April 12, 2009 guys . . .can any 1 giv me a basic program on one-one relationship program in sql Quote Link to comment Share on other sites More sharing options...
Sparda Posted April 12, 2009 Share Posted April 12, 2009 You have two tables, each with a unique field, but one of the tables unique fields must exist in the others unique field. Quote Link to comment Share on other sites More sharing options...
Mike Bond Posted April 20, 2009 Share Posted April 20, 2009 A simple one-to-one select query in MySQL might look like this: SELECT t1.name, t2.salary FROM employee AS t1 INNER JOIN info AS t2 ON t1.name = t2.name; Reference: MySQL Online Documentation at: JOIN Syntax Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.