SELECT t2.Fld4, t1.fld1, t1.fld2, t1.fld3 FROM Table2 t2
  LEFT JOIN table1 t1 ON t1.fld2 = t2.fld4

>I have two tables that I am trying to join as below. Tried a few outer joins but they dont seem to do it
>
>TABLE 1
>-----------
>Fld1 Fld2 Fld3
>--- --- ----
>A1 P1 1
>A1 P2 2
>B1 P3 3
>B1 P4 4
>
>Table 2
>---------
>Fld4
>---
>P1
>P2
>P3
>P4
>P5
>P6
>P7
>P8
>
>
>After join, I want every row from Table 2 to be in the joined table with every row from Table 1, but want Fld2 to be in the Joined table also
>Fld4 Fld1 Fld2 Fld3
>--- ---- --- ---
>P1 A1 P1 1
>P2 A1 P2 2
>P3 A1
>P4 A1
>P5 A1
>P6 A1
>P7 A1
>P8 A1
>P1 B1
>P2 B1
>P3 B1 P3 3
>P4 B1 P4 4
>P5 B1
>P6 B1
>P7 B1
>P8 B1
>
>
>Tia
>Gerard