How to query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

i don't know how too solve this Problem:

I have one table:

ID Reference MsgID
---------------------
1 3234 *
2 3234 5428
3 <NULL> <NULL> *
4 7478 3984 *
5 2034 9454
6 2394 2034

I want to get the Records wich are marked with *. I need the following:

All Records wich Reference is NULL OR All Records wich References and MsgID is NULL OR all Records wich Reference is not in any MsgID Record.

How can i do that?

thanks
yavuz
 
Back
Top