Hi

Im trying to display data from 3 tables.
table 1 and 2 are linked via table 1 ID and table 2 and 3 are linked via table 2 ID.

The problem is that if table 3 does not have a link to table 2 the information in table 2 is not displayed.

How do i display the  information even if there is no link to table three?

Table 1 = UUT_RESULT
Table 2 = STEP_RESULT
Table 3 = PROP_RESULT

My Crystal Report Sql Query :
 SELECT `PROP_RESULT`.`NAME`, `UUT_RESULT`.`BATCH_SERIAL_NUMBER`, `UUT_RESULT`.`UUT_SERIAL_NUMBER`, `STEP_RESULT`.`STEP_TYPE`, `STEP_RESULT`.`STEP_NAME`, `STEP_RESULT`.`STATUS`, `PROP_RESULT`.`DATA`, `UUT_RESULT`.`UUT_STATUS`
 FROM   (`PROP_RESULT` `PROP_RESULT` INNER JOIN `STEP_RESULT` `STEP_RESULT` ON `PROP_RESULT`.`STEP_RESULT`=`STEP_RESULT`.`ID`) INNER JOIN `UUT_RESULT` `UUT_RESULT` ON `STEP_RESULT`.`UUT_RESULT`=`UUT_RESULT`.`ID`
 WHERE  `STEP_RESULT`.`STEP_TYPE`<>'SequenceCall' AND `PROP_RESULT`.`NAME`<>'ButtonHit'
 ORDER BY `UUT_RESULT`.`BATCH_SERIAL_NUMBER`, `UUT_RESULT`.`UUT_SERIAL_NUMBER`