By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

A simple Query in SQL

P: 1
Hai,
My question is, one table contain only one field with 5 rows and another table contain only one table and 5 rows, i want to display the contant of the two tables with in a single query, but no repeatation is allowed.

For Example, i want to show as like this.

Table1 Table2
--------- ---------
Field1 Field2
-------- ---------
A P
B Q
C R
D S
E T

By,
Ur's Friendly,
Karunanidhi.M
Jan 16 '07 #1
Share this Question
Share on Google+
3 Replies


P: 1
This should work for you

For same Example, .

Table1 Table2
--------- ---------
Field1 Field2
-------- ---------
A P
B Q
C R
D S
E T

select t1.Field, t2.Field
from Table t1, Table t2

Hope it helps.

Regards,
Dharini
Jan 16 '07 #2

P: 2
This should work for you

For same Example, .

Table1 Table2
--------- ---------
Field1 Field2
-------- ---------
A P
B Q
C R
D S
E T

select t1.Field, t2.Field
from Table t1, Table t2

Hope it helps.

Regards,
Dharini
hi dharini
this is pavuluri
i think its works
but its comeing 25 rows.
Thanks
Pavuluri
Jan 23 '07 #3

anukagni
P: 53
hi dharini
this is pavuluri
i think its works
but its comeing 25 rows.
Thanks
Pavuluri
Hi,

If ur using the query for reporting select the unique value in the query properties take enique value or enique record as " yes "

anuk prasanna
Jan 23 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.