haw to join two qry

Question

Post reply

haw to join two qry

bbf.kurd

Valued Member

Points: 71
More actions
May 20, 2014 at 6:21 am

#307481

i have to qry any qry have one filed
qry1 qry2
name count
----- -------
a 20
b 10
c 15
haw to join or any try away display
qry3
Result
a | 20
b | 10
c | 15

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65142 More actions · Answer 1

Multple posts

refer to http://www.sqlservercentral.com/Forums/Topic1572540-3412-1.aspx

Far away is close at hand in the images of elsewhere.
Anon.

bbf.kurd Valued Member Points: 71 More actions · Answer 2

David Burrows (5/20/2014)
Multple posts
refer to http://www.sqlservercentral.com/Forums/Topic1572540-3412-1.aspx

no different question

David Burrows SSC Guru Points: 65142 More actions · Answer 3

Well they look the same to me

You will need to provide both queries and how they relate to each other (ie columns to match on)

Far away is close at hand in the images of elsewhere.
Anon.

GouravSaxena1987 SSC Journeyman Points: 93 More actions · Answer 4

Hello,

As per my understanding of your question, you are looking for joining given two tables.

You need to use join features of SQL Server for joining these tables

i.e. Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join.

Please refer below link for more details:

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

timwell SSCertifiable Points: 5315 More actions · Answer 5

Maybe he means something like this?

Select name + ' | ' + CONVERT(varchar(3), [count]) As Result From some_table

Hard to tell. The question doesn't make any sense.

Maybe you need to learn the terms and what they refer to: table, query, column, join, etc...

bbf.kurd Valued Member Points: 71 More actions · Answer 6

this code

Select filmtype , zhmara FROM query2,query3;

Result

why repeat data

i cant Join, Left Outer Join, Right Outer Join because

my query dont have id or id_fkey

just have one file

query2 one fild name filmtype

query3 one fild name zhmara

rhythmk SSCertifiable Points: 7271 More actions · Answer 7

bbf.kurd (5/22/2014)
this code
Select filmtype , zhmara FROM query2,query3;
Result
why repeat data
i cant Join, Left Outer Join, Right Outer Join because
my query dont have id or id_fkey
just have one file
query2 one fild name filmtype
query3 one fild name zhmara

You'll get it as it behaves as CROSS JOIN

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

The real issue here is that we can't see your screen and we have no idea what your tables are like. This is most certainly a really simple thing to do but without these details we are guessing.

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results based on the sample data

Please take a few minutes and read the first article in my signature for best practices when posting questions.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/