Joins

I hope the following query will help you...............
U can join information using the ID column
select  T1.C2,T1.C3,T2.C5 from table1 T1,table T2 where  T1.C1=T2.C4
 

ok
thanks

Hi,
As there is no relation between two tables , in such case we can use cross join.
The query is as follow
SELECT     Employee.FirstName, Employee.City, Demo.ZIP
FROM         Employee CROSS JOIN
                      Demo
 
The o/p is as follows :-
Kiran Chandigharg 54646
Nehal R 54646
Priya D 54646
K Q 54646
Kiran Chandigharg 46546
Nehal R 46546
Priya D 46546
K Q 46546
Kiran Chandigharg 456456
Nehal R 456456
Priya D 456456
K Q 456456
Thanks,
Kiran
 

Hi,
You can try these queries :

1. SELECT C2, C3, C5 FROM TABLE1, TABLE2

2. SELECT c2, c3, c5 from table1 cross join table2

Regards,
Shambhu

Hi

    am not understand your problem clearly.
use the below query to get data from two tables

SELECT column_name(s) FROM table_name1
UNION
SELECT column_name(s) FROM table_name2

With Regards,
Gomathi.P

I don't understand. Raj is in zip codes 12354 and 12345, so I don't understand the results you show.
 
If you want a simple join, then there are plenty of tools you can use to help you do that. You can use SQL Server or Access or Visual Studio. If you want help here, you need to at least be clear about what you need.

Let me explain

there are two tables

t1
columns:
ID
Name
City
t2
Columns
ID
ZIP

Now i need a table as end result having columns Name , City , ZIP

NOTE:- t1
ID Name City
1 Raj chd
2 Karan chd
3 Raj chd

t2
ID ZIP
1 12354
2 12354
3 12345

result should be

Raj chd 12354
Raj chd 12354

etc.....