		Computer Forum > Computer Forums > Programming Forum > Mysql Forum
MySQL Select 2 columns as 1?

Mysql Forum Mysql Forum

MySQL Select 2 columns as 1?

Mysql Forum

#1 (permalink)

10-01-2008, 03:16 AM

PHPMine.com PHPMine.com is offline

Junior Member

Join Date: Sep 2008

Posts: 4

MySQL Select 2 columns as 1?

say i have a table of students and another table of professors. what is the syntax to create a result with the names of the students and the names of professor name

« Any php & mysql programmers out there? I need help!? | MySQL: How do I display a certain amount of (text) characters? »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mysql column based on calculation of two other columns?	Hello	Mysql Forum	0	09-03-2008 02:48 PM
In MYSQL, Can I have the sum of two columns in 1 query?	pot	Mysql Forum	0	06-05-2008 01:51 PM
Is it too much a MySQL table with over 200 columns?	Anonymous	Mysql Forum	0	01-11-2008 02:47 AM
In MySQL, does having too many columns make a difference when those columns are not	Anonymous	Mysql Forum	0	01-11-2008 02:34 AM
newbie: accessing columns in a select	Jeff	PHP Forum	2	11-24-2005 12:00 AM

All times are GMT. The time now is 04:42 AM.