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

white space in table and field name

100+
P: 232
table1 name =student information
table1 fields=rollno,first name,last name,address,phone no
table2 name=project
table2 fields=rollno,project title,Subject Area
i cant make changes in tables
plz help me to write a query to show fields rollno,first name,last name,address,phone no,project title
Oct 20 '08 #1
Share this Question
Share on Google+
4 Replies


Markus
Expert 5K+
P: 6,050
Try a tutorial http://www.tizag.com/mysqlTutorial/mysqlquery.php
Oct 20 '08 #2

100+
P: 232
Try a tutorial http://www.tizag.com/mysqlTutorial/mysqlquery.php
i want in the query in mssql ................................................
Oct 20 '08 #3

Atli
Expert 5K+
P: 5,058
i want in the query in mssql ................................................
Then try Googling for a MSSQL tutorial.

Nobody here will do your work for you. You will have to do that yourself.
If you run into any specific problems, however, we are happy to help you out.

The only thing we ask is that you at least try to do this yourself, and if you need help, provide the necessary information we need to help you. Like say; the type of SQL server you are using.

Before you post again, please read through our Posting Guidelines, which we expect all members to follow when posting here.

Also, I have moved this thread over to the Microsoft SQL Server forum, seeing as it is not really related to PHP in any way.

Thank you.
Moderator
Oct 20 '08 #4

ck9663
Expert 2.5K+
P: 2,878
Nice one mod :)

Let's just guide him....

You need to use SELECT to get your result set, WHERE to filter it out and JOIN to relate all your tables.

Happy coding.

-- CK
Oct 21 '08 #5

Post your reply

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