fruit
id            name
1            apple
2            banana
3            orange

car
id            name
1            toyota
2            bmw
3            suzuki

market
id            name            type            type_id
1            woolworth        car            1
2            coles            fruit          3
3            kmart            car            2

result
id            name            type            type_id            fruit.id            fruit.name            car.id            car.name
1            woolworth        car             1                  null                null                  1                 toyota
2            coles            fruit           3                  3                   orange                null              null
3            kmart            car             2                  null                null                  2                 banana