I have 2 tables that I'm juning
Something like this
SELECT TABLE1.FIELD1, TABLE1.FIELD2, TABLE2.FIELD3
FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.FIELD1 = TABLE2.FIELD1
The problem is that I get the result of the 2 tables is only where TABLE1.FIELD1 = TABLE2.FIELD1 and there are some fields where the value in TABLE.FIELD1 does not exists in TABLE2.FIELD1 thise results are also interesting.
In genneral what I'm trying to do is to get a select of TABLE1.FIELD1, TABLE1.FIELD2 matched up with TABLE2.FIELD3 where TABLE1.FIELD1 = TABLE2.FIELD1 and if the TABLE1.FIELD1 does not exists in TABLE2.FIELD1 then TABLE2.FIELD3 should just be empty - BUT STILL DISPLAYED.
Here is an example of the tabels and the result I looking for
TABLE1
---------------------------------------
NEWDELFI HP_UX server
ODIN T64 server
ODIN2 T64 server
-----------------------------------------
TABLE2
---------------------------------------
NEWDELFI HP responsable
ODIN COMPAQ/HP responsable
---------------------------------------
The result og the select should be
--------------------------------------------------
NEWDELFI HP_UX server HP responsable
ODIN T64 server COMPAQ/HP responsable
ODIN2 T64 server 'NULL'
Is this posible or should I make 2 queryes 1 where TABLE1.FIELD1 = TABLE2.FIELD1 and one where TABLE1.FIELD1 not in TABLE2.FIELD1 and then but them together.
/Larshg
Something like this
SELECT TABLE1.FIELD1, TABLE1.FIELD2, TABLE2.FIELD3
FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.FIELD1 = TABLE2.FIELD1
The problem is that I get the result of the 2 tables is only where TABLE1.FIELD1 = TABLE2.FIELD1 and there are some fields where the value in TABLE.FIELD1 does not exists in TABLE2.FIELD1 thise results are also interesting.
In genneral what I'm trying to do is to get a select of TABLE1.FIELD1, TABLE1.FIELD2 matched up with TABLE2.FIELD3 where TABLE1.FIELD1 = TABLE2.FIELD1 and if the TABLE1.FIELD1 does not exists in TABLE2.FIELD1 then TABLE2.FIELD3 should just be empty - BUT STILL DISPLAYED.
Here is an example of the tabels and the result I looking for
TABLE1
---------------------------------------
NEWDELFI HP_UX server
ODIN T64 server
ODIN2 T64 server
-----------------------------------------
TABLE2
---------------------------------------
NEWDELFI HP responsable
ODIN COMPAQ/HP responsable
---------------------------------------
The result og the select should be
--------------------------------------------------
NEWDELFI HP_UX server HP responsable
ODIN T64 server COMPAQ/HP responsable
ODIN2 T64 server 'NULL'
Is this posible or should I make 2 queryes 1 where TABLE1.FIELD1 = TABLE2.FIELD1 and one where TABLE1.FIELD1 not in TABLE2.FIELD1 and then but them together.
/Larshg