General Development

Combining Two table values to show in the datagrid – DeathFox


Posts: 57
Registered: 04-25-2006
My value in FirstName table is "Albert" and value in LastName table is "Cruz". I have a datagrid on which I wanna show just one column that has "Albert Cruz".

I had the sql statement before which does this but I just reformated my PC Plz help



Posts: 1471
From: Helsinki, Finland
Registered: 03-11-2005
This tutorial page shows first how to do that, before going in to join's usage:

So it's basically :

SELECT Table1.firstname, Table2.lastname FROM Table1, Table2 WHERE Table1.firstname='Albert'

I hope that helps.

Psa 32:5 I acknowledged my sin unto thee, and mine iniquity have I not hid. I said, I will confess my transgressions unto the LORD; and thou forgavest the iniquity of my sin. Selah.

[VoHW] (Help needed) [Blog] (Contact) - Truedisciple (mp3)

[This message has been edited by jari (edited September 28, 2007).]



Posts: 542
From: Toccoa, GA, USA
Registered: 08-15-2006
If you are using mysql, maybe try this...

SELECT CONCAT(Table1.firstname, ' ', Table2.lastname) AS fullname FROM Table1, Table2

the concatenated name (i.e. combined together) will be returned as "fullname".

God Bless!

Sam Washburn

Check out my CCN SpeedGame 2 Blog



Posts: 671
From: Houston, TX USA
Registered: 08-10-2005

[This message has been edited by mastallama (edited September 29, 2007).]