A
ali
I have 2 tables (hard to list down all attributes , so i give an example)
Table 1:
Name Nationality Birthday nickname school
allen Japan 01/Jan/2002 al ABC
SCHOOL
sarah USA 02/Feb/2003 sal BBB
SCHOOL
Nicole UK 03/Mar/2004 Nic CCC
SCHOOL
----------------------------------------------------------------------------
Table 2:
Code Nationality Birthday Remark
01 Japan 01/Jan/2002 good boy
02 USA 02/Feb/2003 Nice girl
03 UK 02/Mar/2004 ok person!
----------------------------------------------------------------------------
Problem:
I tried to join them to produce a new table, but i get double result for
each entry.
----------------------------------------------------------------------------
Question:
Can i use "DISTINCT" OR "GROUP BY" Function ?
If so, please show me the SQL .
Thanks you !
Table 1:
Name Nationality Birthday nickname school
allen Japan 01/Jan/2002 al ABC
SCHOOL
sarah USA 02/Feb/2003 sal BBB
SCHOOL
Nicole UK 03/Mar/2004 Nic CCC
SCHOOL
----------------------------------------------------------------------------
Table 2:
Code Nationality Birthday Remark
01 Japan 01/Jan/2002 good boy
02 USA 02/Feb/2003 Nice girl
03 UK 02/Mar/2004 ok person!
----------------------------------------------------------------------------
Problem:
I tried to join them to produce a new table, but i get double result for
each entry.
----------------------------------------------------------------------------
Question:
Can i use "DISTINCT" OR "GROUP BY" Function ?
If so, please show me the SQL .
Thanks you !