Search results for query: *

I have a table named 'Order Details' that cannot be renamed. When I try to work with it, I get syntax errors I'm assuming are related to the space in the table name. I've tried all combinations of quotes to fix this issue but to no avail. ex "Order Details.name" 'Order Details.name'...

thanks so much.

Do you happen to have a further explanation of aliases? A search didn't bring up anything useful. Here's what I have so far: -------------------------------------------------------- $query = "SELECT modifications.timestamp, clients.name, remote_sites.name, modifications.name, oiversions.name...

Ok, now I'm in the process of displaying the query results via PHP. I'm having trouble with the conventions of of PHP as I'm fairly new to it. How do I construct the inner joins and left joins in a PHP document? Also, when displaying the results with an echo, how do I specify fields with...

Hey one more question, how would I go about displaying results of a field that is blank? Specifically oiversions fields, currently any blank fields are omitted from the results.

got it, you've been a huge help. thanks again.

You're right, worked perfectly. Thanks so much. Do you think you could explain what is happening in that code to me? I'm having trouble following it.

Well, oiversions is only one table so having oiversions2.name wouldn't be giving me any data would it? Is there a way I could use a UNION ALL to join the 2 queries? I've tried with no success to simply add UNION ALL between the 2 to join them but it gives me a "incorrect usage of union and order...

I'm working on a query and I need it to return 2 versions of the same column, so I'm trying to nest the 2nd version in to the first to return the results. Here are my queries: select modifications.timestamp, clients.name, remote_sites.name, modifications.name, oiversions.name from...