> Hi,
>
> I have 02 tables.
>
> pax_table:
> ID, tkt_no, tkt_date, pax_name, freight
> data:
> 20 217 9898 98989 898 01/01/2009 Albert 56000
> 20 217 9898 98989 899 01/01/2009 John 80000
> 20 217 9898 98989 900 01/01/2009 Michael 56000
>
>
> itenary_table
> ID, filght, class, from, to, travel_date, dep, arrival
> data:
> 20 PK-007 M KHI DXB 01/01/2009 12:00pm 03:00pm
> 20 EM-123 N DXB NYK 04/01/2009 01:00pm 05:00pm
> 20 OE-889 A NYK BKK 08/01/2009 06:00pm 09:00pm
> 20 JL-032 U BKK KHI 12/01/2009 02:00pm 04:50pm
>
>
> how do i make the query, which will combine the data of both tables like below:
>
> 20 217 9898 98989 898 01/01/2009 Albert 56000 KHI DXB
> 20 217 9898 98989 898 01/01/2009 Albert 56000 DXB NYK
> 20 217 9898 98989 898 01/01/2009 Albert 56000 NYK BKK
> 20 217 9898 98989 898 01/01/2009 Albert 56000 BKK KHI
>
> 20 217 9898 98989 898 01/01/2009 John 80000 KHI DXB
> 20 217 9898 98989 898 01/01/2009 John 80000 DXB NYK
> 20 217 9898 98989 898 01/01/2009 John 80000 NYK BKK
> 20 217 9898 98989 898 01/01/2009 John 80000 BKK KHI
>
> 20 217 9898 98989 898 01/01/2009 michael 56000 KHI DXB
> 20 217 9898 98989 898 01/01/2009 michael 56000 DXB NYK
> 20 217 9898 98989 898 01/01/2009 michael 56000 NYK BKK
> 20 217 9898 98989 898 01/01/2009 michael 56000 BKK KHI
>
> thanks
>
> naveed

I think you haved typo on result data? Assuming you had typo:

select pax.*, it.from, it.to ;
 from pax_table pax ;
 inner join itenary_table it on pax.tkt_date = it.travel_date

Cetin Basoz

.Net has got better.Think about moving - check my blog:
Blog (main)
Blog (mirror)