Archives of the TeradataForum

Message Posted: Fri, 30 Jul 2004 @ 11:43:38 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All

I have 9 table on which I fire a query

Each table is joined upon 5 columns that are reportdate, lobid, regionid, siteid, serviceid and queueid

The problem is that till now I was joining the table with inner join and getting the results , but the problem came when on of the table dint have data ,

Is there a way so that the query return data in the same case even if the data is missing in one or more table and the result contains the data from table which has data and returns null where ever the data is not found

MKM

	<Prev	Next>		<<First	<Prev	Next>	Last>>