sql problem

Hi friends,

One problem i am facing ,

1> I am having two tables x and y

2> In both the tables (x and y)I am having an primary key User_ID for both the tables.

3> I am inserting the data like (name,adderss) in table x and in table yi am inserting (phone number) at the same time .

4> What my question is i want to retrieve the data (name,address and phone number) from both the table making the use of primary key.

please help ....

Message was edited by:

saamer

[528 byte] By [saamera] at [2007-11-26 23:41:01]