Search results for query: *

Thanks guys It works I put left outter in 2 places and bingo I got the results. I will be honest and say I do not understand why but I will find out Thanks will have a look at the asp link.

How does this look I put 2 outer joins in one for ep_consent and one for ep_prov_diag Are these the 2 correct ones. I am having trouble comming to grips with outer joins and left outer joins Which one do I use. Am frantically search the web for an answer on this. SELECT DISTINCT...

Well back to work today after the weekend. I tried this and all I got is errors. Can you give me an idea of what this line of code should read like. Should it work with Ingres?

Better still here is the query as soon as there is no data in consent status and prov_diag it will not show that record at all. SELECT DISTINCT patient."surname", patient."given_name_1", patient."birth_date", patient."ur_number&quot...

Hmm Right it did not work Will try next idea Any ideas are appreciated.

I have a relational database running under ingresii When I select records with fields from various tables if one of the fields is empty it will not show that record at all. How do I get around this, just because one field is missing data it will not show that record. Any help would be...

I have looked at this data in raw format and it def is empty. Is there something I could put in the formula that will convert a null field to a text of ""

I have done this and still have the problem It is a date/time field formatted as a date. With Ver 7 would it be a y2k bug?

I am using Crystal 7 and dragging data from an ingress database on a sco box The problem is when I get a null field returned it returns the date of 31/12/99 I know this is a null field but why does it return this date. Will upgrading to crystal 8 work or is there a formula to fix this.