F
Filips Benoit
Dear All,
Tables:
COMPANY: COM_ID, COM_NAME, etc.
1 Cola
2 Microsoft
3. Ford
COMPANY_PROPERTY: CPROP_COM_ID, CPROP_PRP_ID, CPROP_VALUE
1 1 True
1 236 False
2 1 True
3 1 True
PROPERTY: PRP_ID, PRP_NAME, etc.
1 Wordwide
236 BadPayer
I want all COM_NAME not mapped to property 236
In this case it shoud return:
Microsoft
Ford
Thanks
Filip
Tables:
COMPANY: COM_ID, COM_NAME, etc.
1 Cola
2 Microsoft
3. Ford
COMPANY_PROPERTY: CPROP_COM_ID, CPROP_PRP_ID, CPROP_VALUE
1 1 True
1 236 False
2 1 True
3 1 True
PROPERTY: PRP_ID, PRP_NAME, etc.
1 Wordwide
236 BadPayer
I want all COM_NAME not mapped to property 236
In this case it shoud return:
Microsoft
Ford
Thanks
Filip