Join tables...

  • Thread starter Thread starter MHakan
  • Start date Start date
M

MHakan

Hi;
I have a two table which of A1 and A2. I want to join these
two tables in A3. The tables are shown bellow and I want their queries.
Thanks for your answers... (date_in and date_exit are order by asc with
DATE...)

A1
Equipment Mark Model Serial Unit_exit date_exit stock rap_explanation
NOTEBOOK ACER TRAVEL 234LC 8ODM000 Europe 02.08.2003 123 321


A2
Equipment Mark Model Serial Unit_in date_in stock rap_explanation
Computer ACER TRAVEL MATE LX210603 Turkey 01.08.2003 456 654


A3

Equipment Mark Model Serial Unit_in date_in Unit_exit date_exit stock
rap_explanation
Computer ACER TRAVEL MATE LX210603 Turkey 01.08.2003 456 654
NOTEBOOK ACER TRAVEL 234LC 8ODM000 Europe 02.08.2003 123 321
 
(Problem with characters I send it again...)

Hi;
I have a two table which of A1 and A2. I want to join these
two tables in A3. The tables are shown bellow and I want their queries.
Thanks for your answers... (date_in and date_exit are order by asc with
DATE...)

A1
Equipment Mark Model Serial Unit_exit
date_exit stock rap_explanation
NOTEBOOK ACER TRAVEL 234LC Europe 02.08.2003
123 321


A2
Equipment Mark Model Serial Unit_in
date_in stock rap_explanation
Computer ACER MATE LX21 Turkey
01.08.2003 456 654


A3

Equipment Mark Model Serial Unit_in date_in
Unit_exit date_exit stock rap_explanation
Computer ACER MATE LX21 Turkey 01.08.2003
456 654
NOTEBOOK ACER TRAVEL 234LC
Europe 02.08.2003 123 321
 
Back
Top