query of 2 tables
Posted: Tue Dec 07, 2004 1:08 am
query of 2 tables
i have this tables :
quote:
--------------------------------------------------------------------------------
Prd
p_makat name
1 aaa
2 bbb
3 ddd
tbl
P_makat Set_no
1 4
2 3
--------------------------------------------------------------------------------
this is the result
quote:
--------------------------------------------------------------------------------
P_makat Set_no
1 4
2 3
3 NULL
--------------------------------------------------------------------------------
2 questions :
1)how can i get the result from the first 2 tables?
2)how can i get for example the result of p_makat=3
from table 1 even if it dosent exist in table 2?
so i will see al table 1 detailes and from table 2 i will see that the valu dosent ecist?
thanks in advane
peleg
i have this tables :
quote:
--------------------------------------------------------------------------------
Prd
p_makat name
1 aaa
2 bbb
3 ddd
tbl
P_makat Set_no
1 4
2 3
--------------------------------------------------------------------------------
this is the result
quote:
--------------------------------------------------------------------------------
P_makat Set_no
1 4
2 3
3 NULL
--------------------------------------------------------------------------------
2 questions :
1)how can i get the result from the first 2 tables?
2)how can i get for example the result of p_makat=3
from table 1 even if it dosent exist in table 2?
so i will see al table 1 detailes and from table 2 i will see that the valu dosent ecist?
thanks in advane
peleg