468,316 Members | 2,150 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

white space in table and field name

232 100+
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
4 3040
6,050 Expert 4TB
Try a tutorial http://www.tizag.com/mysqlTutorial/mysqlquery.php
Oct 20 '08 #2
232 100+
Try a tutorial http://www.tizag.com/mysqlTutorial/mysqlquery.php
i want in the query in mssql ................................................
Oct 20 '08 #3
5,058 Expert 4TB
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.
Oct 20 '08 #4
2,878 Expert 2GB
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.

Similar topics

6 posts views Thread by Grumble | last post: by
2 posts views Thread by shagy | last post: by
1 post views Thread by JA | last post: by
12 posts views Thread by JA | last post: by
2 posts views Thread by empiresolutions | last post: by
4 posts views Thread by Don Miller | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.