Join tables...

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
 
M

MHakan

(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook crashes with Outlook connector 2002 0
Outlook connector crashes outlook 0

Top