Hi..All
I have problem about Join table...
I have 2 tabels for these
Table 1 :
-----------------------------------------------------------------------------------
ID NAME DIAG OPERATE
-----------------------------------------------------------------------------------
1 Jim 001 A01
1 Jim 002 A02
-----------------------------------------------------------------------------------
Table 2 :
---------------------
ID NURSE
---------------------
1 Jenny
1 Anna
1 Mam
---------------------
I want join 2 Table have maximum equal maximum of maximum table
For this example ..maximum of join table = 3
----------------------------------------------------------------------------------------------
ID NAME DIAG OPERATE NURSE
---------------------------------------------------------------------------------------------
1 Jim 001 A01 Jenny
1 Jim 002 A02 Anna
1 Jim 001 A01 Mam
----------------------------------------------------------------------------------------------
OR
----------------------------------------------------------------------------------------------
ID NAME DIAG OPERATE NURSE
---------------------------------------------------------------------------------------------
1 Jim 001 A01 Jenny
1 Jim 002 A02 Anna
1 .NULL. .NULL. .NULL. Mam
----------------------------------------------------------------------------------------------

How I can do?

Narong