Help create query

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

Hello to all

i try to have a view but i am confuse

i have 2 tables (A and B

tb A fields: DateIN_A(date) | Cat(integer) | CatA_ID(text)
tb B fields: DateIN_B(date) | Cat(integer) | CatB_ID(text)

ex

tb A

| DateIN_A | CatA | CatA_ID |
|2007-1-1 | 2 | A |
|2007-1-1 | 4 | B |
|2007-1-2 | 1 | A |
|2007-1-2 | 4 | B |

tb B

| DateIN_B | CatB | CatB_ID |
|2007-1-1 | 15 | B | « not have Cat_ID 'A' in 2007-1-1
|2007-1-2 | 13 | A |
|2007-1-2 | 22 | B |

the view

| DateIN_A | Cat | CatA_ID | CatB | CatB_ID |
|2007-1-1 | 2 | A | null | null |
|2007-1-1 | 4 | B | 15 | B |
|2007-1-2 | 1 | A | 13 | A |
|2007-1-2 | 4 | B | 22 | B |

is this possible thanks
 
SELECT Table1.DateIn_A, Table1.CatA, Table1.CatA_ID, Table2.CatB,
Table2.CatB_ID
FROM Table1 LEFT JOIN Table2 ON (Table1.CatA_ID = Table2.CatB_ID) AND
(Table1.DateIn_A = Table2.DateIn_B);

Hope that helps!
 
thanks a lot Jeff

SELECT Table1.DateIn_A, Table1.CatA, Table1.CatA_ID, Table2.CatB,
Table2.CatB_ID
FROM Table1 LEFT JOIN Table2 ON (Table1.CatA_ID = Table2.CatB_ID) AND
(Table1.DateIn_A = Table2.DateIn_B);

Hope that helps!
 
Back
Top