white space in table and field name

[kkshansid]

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

[Markus]

Try a tutorial http://www.tizag.com/mysqlTutorial/mysqlquery.php

[kkshansid]

Try a tutorial http://www.tizag.com/mysqlTutorial/mysqlquery.php

i want in the query in mssql ................................................

[Atli]

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

[ck9663]

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