Sql Help Or Advice Need

[rastaman46]

Hey again well

 

im trying to call 2 tables from sql "t1" content name "t2" got all records im matching them up by ID

 

but result im get its row me in single rows Same name comes up few times diferent info same name

 

but i need if name is same and have few recods im like to display like this

 

"Name"-->first-->second-->and so on

 

not like

 

"Name" --> first

"Name" --> second

"Name" -->and so on

 

did im was clear???

[ManiacDan]

but result im get its row me in single rows Same name comes up few times diferent info same name

You're going to have to rewrite this in English, this makes no sense at all.

 

Taking a complete shot in the dark: SELECT DISTINCT

 

[Barand]

That is way JOINS work - for each matching record you get the data from t1 joined with matching data from t2.

 

To get what I think you want you will need to use GROUP BY coupled with GROUP_CONCAT()

 

SELECT t1.id, GROUP_CONCAT(t2.name SEPARATOR ', ') as names
FROM t1
INNER JOIN t2 ON t1.id = t2.id
GROUP BY t1.id

Edited October 16, 2012 by Barand

[rastaman46]

Hey and thanks for replay its most look my target but only get one result? Im got more then one name in it

[ManiacDan]

Im got no idea what you're talking about.

 

Show what your tables look like, give us 6 rows of example data from each table.

 

Show what your desired result looks like.

[rastaman46]

First table

 

Table 2

 

 

here what im trying to do

 

[Barand]

Still guessing. If this is wrong you'll have to explain better or run with it yourself.

 

SELECT t1.betid, t1.bet_name, GROUP_CONCAT(t2.chosen_team SEPARATOR ', ') as teams
FROM t1
INNER JOIN t2 ON t1.betid = t2.betid
GROUP BY t1.betid

[rastaman46]

Thanks works but haw do im add extra info in here

GROUP_CONCAT(t2.chosen_team SEPARATOR ', ') im still want to display member id and bett size next to name ???

[ManiacDan]

"I NEED GET LIKE THIS"

 

Translation: Similar to this, but with extra information which fundamentally changes the nature of the query

 

 

[Barand]

GROUP_CONCAT(CONCAT(t2.member_id, '-', t2.chosen_team) SEPARATOR ', ')

 

http://dev.mysql.com/doc/refman/5.6/en/group-by-functions.html#function_group-concat

Edited October 17, 2012 by Barand

[rastaman46]

Thanks for your time im ill take over here

 

Thanks for your time