i have 2 tables one is master secound client 1-N th ( client table have many entries that are pointed to one entry in the master) and also have an type field.
now what i need is a sql select statment thats gives me
master structure: person table
person_NR - PK
name - varchar
detail structure: contact table
contact_NR - PK
person_NR - FK
value - varchar
type - int
1. gives me ALL person.name and the contact.value thats have the contact.type 70 and all the rest of master thats have a different contract.type as 70 but if the more as 1 result should be only one time
what i wanna have is just somthing like select * from person (any entries one time) and also the value that have the type 70 or if they dont null must be in.
person 1 , hallo ( have the type 70 and it's hallo )
person 2 , hallo ( have the type 70 and it's hallo )
person 3 , hallo ( have the type 70 and it's hallo )
person 4 , null ( donot have the type 70 result = null )