JOIN

[dev_kc]

I have 2 tables Details,Mstr.
Mstr table contains(PSNO,NAME,DOB,DOJ)=>PSNO- PK
Details(PSNO,NAME,PH,SAL_ACC,ADV,DT_PREP)PSNO-FK
In Grid i need to display
SAL_ACC NAME ADV DT_PREP
12345 abc 150 5/25/2009
12345 abc 300 5/30/2009
12345 abc 200 6/11/2009

how do i do ths,please help

[vb5prgrmr]

Unless I am misunderstanding you, all of your fields are in the details table, No need for a join.

Good Luck

[debasisdas]

try the following

select b.SAL_ACC ,b.NAME ,b.ADV ,b.DT_PREP from mstr a,detail b where a.psno=b.psno

[Ancient Dragon]

try the following

select b.SAL_ACC ,b.NAME ,b.ADV ,b.DT_PREP from mstr a,detail b where a.psno=b.psno

As vb5prgrmr pointed out, a join is not even necessary because all the data can be obtained from one table.

[dev_kc]

But how can i display d results in the grid,that i dnt knw

[dev_kc]

There can be 15 rows belonging to same person,but with different PREP_DT,i need to show all of then,like i have mentioned earlier,this i dnt know,thats why i made PSNO as foreign key in Details table as a single PSNO vil be having more than 1 records,and i need to display all of them.....

[debasisdas]

As vb5prgrmr pointed out, a join is not even necessary because all the data can be obtained from one table.

what if i want only matching data based on both the tables ?

in that case a join is compulsory.